Remove macros on save as

[Guest]

Hi all,
I have a problem with macros.
I have a Workbook that has macros. It generates some data to the sheets, and
it saves herself in another name.
But in that copy I don't want the macros anymore.
Can I save it without macros?

Thnx your answer

 

[Tom Ogilvy]

You would need a macro to remove the macros. I suspect you would need to
save a copy of it and then remove the macros from that copy.

http://www.cpearson.com/excel/vbe.htm

will provide the information you need (Chip Pearson's site).

 

[Sharad Naik]

That's not possible as such.
What you can do is, instead of saving as,
use workbooks.add method to create a new workbok,
copy the sheets from the workbooks having macro, to the new workbook and
then save the new workbook giving desired name.

Sharad