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?

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

HTH

Bob

"Erin" wrote in message
...
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?

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 wrote:

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?

--

Dave Peterson

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" wrote:

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 wrote:

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?

--

Dave Peterson
.

There weren't any sheet modules?

(I don't have any other guesses.)

Erin wrote:

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" wrote:

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 wrote:

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?

--

Dave Peterson
.


--

Dave Peterson