Have you tried also removing the modules that these macros were formerly in?
Choose Tools Macros Visual Basic Editor. The files you have open should
be listed in the upper left pane of the Visual Basic Editor. If they aren't,
try View Project Explorer. You may have to expand the file you're
interested in to see its modules. Then right-click the module(s) and choose
Remove Module...

It will ask you if you wish to export it before removing. If it's empty you
will say No.

I'm not 100% sure this will prevent the message you're getting, but it's the
first thing I'd try.

Keith

"EllenM" wrote:

Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is opened?

Thanks,
Ellen