How do I totally remove macros from a Workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have followed the 'Office Assistant' directions, and deleted it from under
Tools -> Macros -> etc. According to the macros list, there are no macros in
the file; however, when I open the file it still asks me to enable/disable
macros. Is there a way to get it to stop asking me that, without changing my
security settings (i.e. I don't want any macros in my file and I don't want
to set my security level to 'low').
 
hi,
you also have to remove the modules.
goto tools>macro>visual basic editor or press Alt+F11
In the left pane, click the project name.(file Name)
this will expand the project.
click on any modules then in the editor click file>remove
module.
it will ask if you want to save it, click no.
 
You not only have to delete the Macro but also the module that the Macro was
in to remove the start-up prompt,
Go Alt and F11 to open the VB Editor,
On the left you should see one or more Modules,
Right click each one and select 'Remove', click 'No' to the prompt to save,
Go Alt and F11 to close the VB Editor,
Save the file,
Regards,
 
Back
Top