Hello
I have 3 Macros in my work book. Each one is for a shift(1,2,3) user to save a copy as the following:
ActiveWorkbook.SaveCopyAs ("T:\Mellie79\MFG Schedule\Bulk Synthesis MFG Schedule 1st Shift-" & Format(Now(), "DD-MMM-YYYY") & ".XLSM")
Typically the user would only save once a shift...