Excel sees macros which are not there.

T

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.
 
T

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.
 
T

Terry

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

Problem solved, thank you very much!
 
Top