Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros

Shashi Bhosale wrote:

Hi ,

I need a code to remove all the macros/codes from workbook so that when i
open the file again i don't get the macro warning.

Thanks in advance,

Shashi

--

Dave Peterson