In order to prevent users overwriting my blank master workbook I want to force users to "Save As" so they can't save the workbook with the same name as the master file. I've found some VBA code to do this, which works great, but it also stops me from modifying my file and saving it as the name of the master file. I need to make other users 'Save As', but still allow me to Save as normal.
The code I'm using for the 'Save As' is this:
I think I can use this to check whether the user is me or not, but as a newbie to VBA whose VBA skills are basically copy/paste blocks of code found online and tweak the odd word here or there, I'm not sure how this would fit in with the original code and where I'd need 'Else', 'End If' and such like. At the moment I get compile errors when I try and add this after the 'Private Sub Workbook_BeforeSave':Please Login or Register to view this content.
Any advice gratefully received.Please Login or Register to view this content.
Bookmarks