remove macros and all code from a worksheet/workbook

M

mgm

I would like to remove all code from my workbook/worksheet. How is this
done.
The form I designed generates a security msg. and the endusers may not be
able or allowed to adjust their security settings... thanks
 
P

Paul B

mgm, 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
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top