hi
see this site....
http://cpearson.com/excel/vbe.htm
it tells how to manipulate macros with macros.

regards
FSt1

"karmela" wrote:

Hi,
I have workbook where should have access more persons from my company and
need to change it. On closing it I have macro (in module of this workbook) to
delete some sheets and columns, and save it with another name. This new
workbook is read only, but in this way it contents all macros from the first
workbook.

How can I automatically delete all macros in that new file?
Or is there any better solution?

Thank you in advance, karmela