Save as Problem

[rajeshvk33]

3 macro I Recorded in Excel named Book1.xls Each for different purpose.
Now i Record another macro,in that i record Save as also.So if give save as Book2.xls.

In Book2.xls also all the macro are getting saved.How to avoid save of Macro in Book1.xls to Book2.xls.

Please suggest.

Thanks.

 

[westconn1]

you should avoid using the default workbook names when saving anyway

save as really just changes the name of the workbook and saves the latest changes, so yes all code will go with it

to record you macros, use a different workbook without macros, record the macro to the workbook with macros, or the other way around, it is no problem working with multiple workbooks, just need to specify which book you are working with