Excel 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 ToolsMacroMacrosAll 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 "

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Terry" wrote in message
...
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 ToolsMacroMacrosAll 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.

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.


"Norman Harker" wrote in message
...
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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Terry" wrote in message
...
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 ToolsMacroMacrosAll 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.

Debra Dalgleish has a manual technique documented at:

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

Terry wrote:

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.

"Norman Harker" wrote in message
...
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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Terry" wrote in message
...
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 ToolsMacroMacrosAll 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.










--

Dave Peterson

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

Problem solved, thank you very much!

"Dave Peterson" wrote in message ...
Debra Dalgleish has a manual technique documented at:

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

Debra does nice work.

Terry wrote:

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

Problem solved, thank you very much!

"Dave Peterson" wrote in message ...
Debra Dalgleish has a manual technique documented at:

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


--

Dave Peterson