Macro help

  • Thread starter Thread starter Phil vK
  • Start date Start date
P

Phil vK

I have a file that use to have 2 macros in it. I deleted them by going to
Tools>Macros, 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.... file>remove module.

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

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

Have a look under Insert>Name>Define


Gord Dibben MS Excel MVP
 
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
 
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
 
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.
 
After Alt + F11 hit CTRL + r

That opens the Project Explorer.


Gord Dibben MS Excel MVP
 
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?
 
Its baaaackkk!!! I am now being asked to enable or disable macros even
though I've deleted the "module 1". When I go to ALT>F11, 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
 
Back
Top