Removing Macros

[Erin]

Hi!

I'm getting that "Enable Macros?" message when I open a workbook even though
I've taken the usual steps to remove any macros in the workbook. I've gone
into the VB editor and removed any invisible code (there weren't any modules
or forms), and I've deleted any defined names in the workbook. I've never
had these steps not work before. Any ideas?

 

[Bob Phillips]

Have you looked in the ThisWorkbook module, and the sheet modules?

HTH

Bob

 

[Dave Peterson]

Maybe you have something under in a sheet module--or under ThisWorkbook???

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Erin]

I had already tried the "contextures" method. Those were the steps I
performed, but I'm still getting the macro notice. There weren't any modules.

 

[Dave Peterson]

There weren't any sheet modules?

(I don't have any other guesses.)