Completely eliminating macros from an excel file
Just looking for advice on how to eradicate macros from an excel file.
I originally created two macros in the monthly management accounts file
which I then deleted but now everytime I open the file it asks me do I want
to enable or disable macros.
When I go into Tools/Macros there are no macros there. Any way of eliminating
the enable/disable macros message? It is an Excel 2003 file. Any help would
be welcome as I am worried that if I have to e-mail the file,sometimes recipients e-mails
will block a file with perceived macros inside.
Thanks,
Damian
Comments
Miss local macros
|
Sat, 13/03/2010 - 11:26 |
Permalink
I think that approach will miss the local code stored in the "sheet" objects. I believe that has changed in later versions so it may depend on the version of excel you are using.
Cheers, Kerry.
Do it in visual basic editor
Tools/Macros/Visual basic editor
In the left hand pane you will see a tree that includes VBAProject/Modules
Delete any modules that are listed under "Modules" - there is probably one there, possibly an empty module called "Module1" - rightclick on the module and select "Remove Module1".
If you have any Excel 4 macros this will not be effective in removing them but try this first and if you still have the macro alert then let us know.
With kind regards
Clint Westwood