keeping original workbook open when saving
Can we see the code you're using?
Are we talking about a single workbook, or two workbooks? I presume a
single workbook - that is, the macro is deleting rows in the 'master'
workbook and saving the changed version of it under a different name?
"steven" wrote:
hello,
i work on a master workbook where a macro deletes rows from a worksheet.
After deleteing the rows I want the resulting workbook to be saved with a
specific filename.
I am able to go this far but then the I want to be able to revert to the
master workbook (prior to the rows being deleted) and run another macro for
different rows to be deleted and save the new file with another filename. And
then revert again ect.
How can I acomplish this? Cause my macro results to the master workbook to
be closed with the active worbook beng the saved worbook.
Thank you,
Steven.
|