After Alt + F11 hit CTRL + r

That opens the Project Explorer.


Gord Dibben MS Excel MVP


On Sun, 8 Feb 2009 08:12:00 -0800, Phil vK
wrote:

Thank you FSt1, however when I bring up the VB Editor via Alt+F11 I only get
a blank gray screen and don't see anything I can expand.

Thanks, Phil

"FSt1" wrote:

hi
you may have deleted the macros but you didn't delete the module they were
in and that is what is causing the message.
bring up the vb editor ie Alt+F11.
in the project window(far left), expand your project(file)
keep expanding till you see modules.
double click any module to open it. check make sure it's empty then on the
vb menu bar.... fileremove module.

the other update links. you make have deleted a sheet but there may be more.
on the excel menu bar.....
toolsoptions edit tab uncheck Ask to update automatic links

Regards
FSt1

"Phil vK" wrote:

I have a file that use to have 2 macros in it. I deleted them by going to
ToolsMacros, however when I open the file I am asked to either enable or
disable macros. I also get asked to update the sheet because it references
other sheets (which I thought I also removed). How can I stop the macro
messages and is the reference to other sheets related to the macro issue?