Remove macros on save as
 

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

Remove macros on save as
 

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).

--
Regards,
Tom Ogilvy

"Quake" wrote in message
...
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

Remove macros on save as
 

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

"Quake" wrote in message
...
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