Disabled macros

J

Jolene

Every time I open one of my excel documents it asks me if I want to disable the macros or enable them. The only thing is there are no macros to be enable, they were all deleted. How can I stop this message from coming up, without starting my whole document from scratch?
 
B

Bob Phillips

Jolene,

Two things to check.

Even if you have deleted the macros, if you haven't removed the code
modules, you will still get the message.

Have you checked the worksheet and ThisWorkbook code modules, they may have
macros.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Jolene said:
Every time I open one of my excel documents it asks me if I want to
Click to expand...
disable the macros or enable them. The only thing is there are no macros to
be enable, they were all deleted. How can I stop this message from coming
up, without starting my whole document from scratch?
 
P

Paul B

Jolene, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Jolene said:
Every time I open one of my excel documents it asks me if I want to
Click to expand...
disable the macros or enable them. The only thing is there are no macros to
be enable, they were all deleted. How can I stop this message from coming
up, without starting my whole document from scratch?
 
P

Paul B

Jolene, your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Top