Completely getting rid of unused macros in XL?
 

I started an XL document and was going to use macros. I recorded one and
used it a bit and decided that it was not going to save any time so I deleted
it along with the button I had created. Now, even though I am not using
Macros, I still get the warning when I open the document. I know I can add
it to my XL Start folder to avoid this however I do not want my other staff
members to have to do that. I also do not want them to lower their security
settings. Does anyone know how I can just get rid of all of the macros so XL
will not ask any more?

Completely getting rid of unused macros in XL?
 

Alt+F11 to open the Visual Basic Editor. Find you file in the project
explorer window (top Left or Ctrl+R to display it) and select Module1.
FileRemove Module1. Click no when prompted to export.

Hope this Helps
Rowan

Aaron wrote:
I started an XL document and was going to use macros. I recorded one and
used it a bit and decided that it was not going to save any time so I deleted
it along with the button I had created. Now, even though I am not using
Macros, I still get the warning when I open the document. I know I can add
it to my XL Start folder to avoid this however I do not want my other staff
members to have to do that. I also do not want them to lower their security
settings. Does anyone know how I can just get rid of all of the macros so XL
will not ask any more?

Completely getting rid of unused macros in XL?
 

Maybe this helps:
http://www.erlandsendata.no/english/...eleteallmacros

Wolf

"Aaron" wrote:

I started an XL document and was going to use macros. I recorded one and
used it a bit and decided that it was not going to save any time so I deleted
it along with the button I had created. Now, even though I am not using
Macros, I still get the warning when I open the document. I know I can add
it to my XL Start folder to avoid this however I do not want my other staff
members to have to do that. I also do not want them to lower their security
settings. Does anyone know how I can just get rid of all of the macros so XL
will not ask any more?