 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / April 2004Excel sees macros which are not there.
I hope this is the right forum. . . I moved a number of Excel97 files to Excel XP and now when I open some of those files, I get the following error message: "Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level." I created one particular workbook a couple of years ago and I'm sure there are no macros in it. Many formulas, but no macros. But just on the off-chance that a macro is hiding somewhere, how would I find it? I have already clicked on Tools>Macro>Macros>All Open Workbooks and there is no indication of any macro in any of the 10 spreadsheets which comprise this particular workbook. If there is any other way to identify a macro, I'd appreciate knowing about it. And if there are no macros, why would Excel think there is? Any help on this will be much appreciated. Thanks. Hi Terry! There may be some remnants of code left. See: http://www.cpearson.com/excel/vbe.htm Go to heading: "Deleting All VBA Code In A Project "  SignatureRegards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. >I hope this is the right forum. . . > [quoted text clipped - 23 lines] > > Any help on this will be much appreciated. Thanks. Uhhh, truth to tell, Norm, I don't really know what to make of the VBA procedure you referred me to. I think I was hoping for a slightly less sophisticated answer. There's no reason to believe there are any "remnants of code left" because I didn't put any there in the first place. I appreciate your response, but I still need a bit of help on this. VBA is something I've not yet learned. If you have another suggestion, I'm open for it. Thanks. > Hi Terry! > [quoted text clipped - 40 lines] > > > > Any help on this will be much appreciated. Thanks. Debra Dalgleish has a manual technique documented at: http://www.contextures.com/xlfaqMac.html#NoMacros > Uhhh, truth to tell, Norm, I don't really know what to make of the VBA procedure you referred me > to. I think I was hoping for a slightly less sophisticated answer. There's no reason to believe [quoted text clipped - 46 lines] > > > > > > Any help on this will be much appreciated. Thanks. SignatureDave Peterson ec35720@msn.com I followed the instructions you pointed me to and apparently that did the trick. Problem solved, thank you very much! > Debra Dalgleish has a manual technique documented at: > > http://www.contextures.com/xlfaqMac.html#NoMacros Debra does nice work. > I followed the instructions you pointed me to and apparently that did the trick. > [quoted text clipped - 3 lines] > > > > http://www.contextures.com/xlfaqMac.html#NoMacros SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.