Excel sees macros which are not there.

[Terry]

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.

 

[Norman Harker]

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 "

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Terry]

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.

 

[Dave Peterson]

Debra Dalgleish has a manual technique documented at:

http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Terry]

I followed the instructions you pointed me to and apparently that did the trick.

Problem solved, thank you very much!

 

[Dave Peterson]

Debra does nice work.

I followed the instructions you pointed me to and apparently that did the trick.

Problem solved, thank you very much!