Deleted all macros, but still get warning

[David D.]

I am using Excel 2000.

I created some macros in a spreadsheet. (The sheet contains data, computed
data, and a chart).

Of course, I got the macro warning dialog box whenever I first opened the
spreadsheet.

I have now deleted all of the macros, but I still get the initial warning
about enabling or disabling macros.

How do I get the spreadsheet to know that it contains no macros?

(I tried just copying the cells to a new workbook, but then, when I open the
new file, I get a message about linked spreadsheets).

- David

 

[Debra Dalgleish]

You also have to remove the modules on which the macros were stored.
There are some instructions in the Excel FAQs:

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

 

[David D.]

Thanks, Debra.

That did the trick.

- David