View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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