Hi, I have a Save As macro that saves my spreadsheet to a different location. My problem is after executing the macro, the new saved spreadsheet file is now the one opened. Can the macro be modified to still show the original spreadsheet file so that I can still continue to work on it?
Here's my macro:
Code
Sub SAVEAS()ActiveWorkbook.SaveAs Filename:= "C:\Documents and Settings\Desktop\Book1_" & format(now(),"YYYYMMDD") & ".xls"
End Sub
TIA!