DenverWill81
New Member
- Joined
- Apr 29, 2022
- Messages
- 7
- Office Version
- 2016
Okay... this seems tricky and I don't have any good examples of code to post but here's what I'm trying to do...
I have this userform:
The XXXX part will refer to a project name based on which 'Delete' button was click and I think I can figure that out.
Clicking "Yes" will just plow forward with the project deletion macro.
Clicking will "End" all macros.
And what I'd like to have happen when you click the "Save Backup" button is for a macro to save a back up file with the same name as the current one plus YYMMDD_HH:MM but stay in the current file? So just create a backup to the side without actually switching to the backup. I could also do a Save As with the time stamp and then reopen the original file but I'm not sure if that would work in the middle of a macro.
Is that even possible?
I have this userform:
The XXXX part will refer to a project name based on which 'Delete' button was click and I think I can figure that out.
Clicking "Yes" will just plow forward with the project deletion macro.
Clicking will "End" all macros.
And what I'd like to have happen when you click the "Save Backup" button is for a macro to save a back up file with the same name as the current one plus YYMMDD_HH:MM but stay in the current file? So just create a backup to the side without actually switching to the backup. I could also do a Save As with the time stamp and then reopen the original file but I'm not sure if that would work in the middle of a macro.
Is that even possible?