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
Replies (3)
Please login or register to join the discussion.
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
Simple but so effective
Clint,
Thanksa million, that worked perfectly.
All the best
Damian
Miss local macros
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.