Can't get rid of macros

[R Titterton]

I have written some simple macros in a worksheet. I have then deleated
them, however when I open the file I get the standard security warning
message about macros, asking whether I wish them enabled or disabled.
Without changing the default security settings to disable this feature, how
can I strip the file of the offending macro so that the warning does not
come up?

Robt

 

[Peo Sjoblom]

You need to remove the module they were in, open the workbook in question,
press Alt + F11. In the project pane to the left find your workbook, right
click the module(s),
select remove module and when prompted to export answer nay. Repeat if there
are more than one.
Press Alt + Q to close the VBE. save the file

 

[Paul B]

Robt, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Gord Dibben]

Robt

You must also remove the module(s) the macro were created in.

Debra Dalgleish has fix with pictures at her website.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Gord Dibben XL2002

 

[R Titterton]

Thanks folks. I will give the solution a chance when I get to work on
Monday.

RobT