Macro

  • Thread starter Thread starter erirog
  • Start date Start date
E

erirog

I have deleted the macros out of a worksheet but when the
worksheet is opened it still comes up with the message to
enable or disable macros. Since there are no macros in
this particular worksheet, I would like for that not to
come up. How would I do that?

Thanks
 
erirog said:
I have deleted the macros out of a worksheet but when the
worksheet is opened it still comes up with the message to
enable or disable macros. Since there are no macros in
this particular worksheet, I would like for that not to
come up. How would I do that?

Thanks
Click to expand...

You have to delete the module that the macro was in, as well as having
deleted the macro itself. (This is analogous to deleting a Windows folder as
well as the files that it contained.) Go into the VBA editor, select the
module in the 'tree list' and delete it.
 
Back
Top