Hello,
Using the code below, completed workbooks are saved to a network drive each day. After saving it to the new drive, the user can delete the old data from the workbook on their computer and reuse it.
I noticed that after running the macro (saving to the network with the new name), you can accidentally delete the data and hit Ctrl+S and it clears it from the saved copy on the network drive.
Is there any way to prevent that from happening without closing the active workbook?
Any suggestions are appreciated. Thanks
Using the code below, completed workbooks are saved to a network drive each day. After saving it to the new drive, the user can delete the old data from the workbook on their computer and reuse it.
I noticed that after running the macro (saving to the network with the new name), you can accidentally delete the data and hit Ctrl+S and it clears it from the saved copy on the network drive.
Is there any way to prevent that from happening without closing the active workbook?
Any suggestions are appreciated. Thanks
VBA Code:
Dim wkb As Workbook
Set wkb = ActiveWorkbook
wkb.SaveAs "Z:\Projects\"new workbook name….."
Last edited by a moderator: