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