Completely eliminating macros from an excel file

Completely eliminating macros from an excel file

Didn't find your answer?

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.

avatar
By nogammonsinanundoubledgame
04th Mar 2010 09:37

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

Thanks (0)
avatar
By User deleted
04th Mar 2010 09:49

Simple but so effective

Clint,

 

Thanksa million, that worked perfectly.

 

All the best

Damian

Thanks (0)
avatar
By kerrym
13th Mar 2010 11:26

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. 

Thanks (0)