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?

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?

With regard to the links issue................you may also have links in
named ranges.

Have a look under InsertNameDefine


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 09:24:15 -0800, 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?

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?

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?

Thank you FSt1, however when I hot Alt+F11, all's I get is a blank gray
screen. I 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?

When you Alt+F11, the screen may be blank, but at the left side in the
VBAProject are there any Modules, if so right click on the module and
select remove Module, don't export it, also if there is any VBA code
at all in the workbook ie: Workbook module, Worksheet Module, you will
be asked if ..You want to enable Macros.

Thank you all for the help. I removed the only Module I found and that
seemed to do the trick. Is there a quick explanation somewhere I can access
to see what "modules" do?

"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?

Its baaaackkk!!! I am now being asked to enable or disable macros even
though I've deleted the "module 1". When I go to ALTF11, I get a list of
"Microsoft Excel Objects" but no Modules. I also get a line that says
"AcrobatPDFMaker (PDFMaker.xla)" that requires a password to expand. I am
incredibly lost...please help.

Thanks,Phil

"Phil vK" wrote:

Thank you all for the help. I removed the only Module I found and that
seemed to do the trick. Is there a quick explanation somewhere I can access
to see what "modules" do?

"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?