Save a file without saving the macro
 

Hello guys,

I would like to know how to save a file without saving the macro that
generates the save mode.

Ina

Save a file without saving the macro
 

Simplest to go to the VBE (Alt + F11) and delete the module that holds the
macro's:
Ctrl + R, right-click the module and do remove Module1 or whatever it is
called.
Make double-sure you remove the right module and not something else that is
important to keep.
Then save the workbook.

RBS

"ina" wrote in message
oups.com...
Hello guys,

I would like to know how to save a file without saving the macro that
generates the save mode.

Ina

Save a file without saving the macro
 

yes but this file will be save everyday I need to do a script that
remove it automatically without going everyday to delete it.

Ina

Save a file without saving the macro
 

Look at this:
http://www.cpearson.com/excel/vbe.htm

RBS

"ina" wrote in message
oups.com...
yes but this file will be save everyday I need to do a script that
remove it automatically without going everyday to delete it.

Ina

Save a file without saving the macro
 

thanks I tried that but and had a lot of problem because to delete it
is better to copy the file in another place and after delete. but I
result my problem like this

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
ActiveWorkbook.SaveAs Filename: ... this copy only the result in
the sheet but not the code.

Ina