How do I totally remove macros from a Workbook?

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 toolsmacrovisual 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 fileremove
module.
it will ask if you want to save it, click no.

-----Original Message-----
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').
.

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,
"Amanda Battist" wrote in message
...
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').