hidden/unintentional macros ?

J

JayDe

I have a spread sheet that has been collecting data over a
3 year period. When I created it, it had no macros or
functions, just a collection of data. Have never had a
warning (and I've kept the macro warning setting on
through Exel version changes) about the sheet containing
macros, as compared with other sheets.
I'm currently using Exel XP, and still had no problem,
till I reformated a couple of days ago, and now Exel
throws a warning every time I open the sheet.
No macros are listed in Tools>Macros, so the question is:
How does one 'save' the sheet clean, without any unwanted
macros ?
 
S

SidBord

Don't know for sure, but I got this gut feeliing it's a
security problem of some sort.
 
L

Lady Layla

Have you looked at your Security tab for Macros (Tools Options Security
Macrosecurity) See what level it is set on and see whether you have addin box
checked or not


: I have a spread sheet that has been collecting data over a
: 3 year period. When I created it, it had no macros or
: functions, just a collection of data. Have never had a
: warning (and I've kept the macro warning setting on
: through Exel version changes) about the sheet containing
: macros, as compared with other sheets.
: I'm currently using Exel XP, and still had no problem,
: till I reformated a couple of days ago, and now Exel
: throws a warning every time I open the sheet.
: No macros are listed in Tools>Macros, so the question is:
: How does one 'save' the sheet clean, without any unwanted
: macros ?
 
D

Dave Peterson

Did you clean up everything under each worksheet and under ThisWorkbook?

ctrl-a, delete
for each of those type modules.
 
Top