Hey,
I have a spreadsheet template that a few rather un-IT people will be editing and they have a habit of saving over the template once they've built the file.
So, I need a piece of VBA code that when the person clicks save, it checks the current file name against the template name and if they match, pops up a msgbox that says something like "Please use SAVE AS and save as another file name!"
My VBA knowledge is poor and tbh, I should learn it myself but I use it that rarely i'm not sure it's worth it.
I have a spreadsheet template that a few rather un-IT people will be editing and they have a habit of saving over the template once they've built the file.
So, I need a piece of VBA code that when the person clicks save, it checks the current file name against the template name and if they match, pops up a msgbox that says something like "Please use SAVE AS and save as another file name!"
My VBA knowledge is poor and tbh, I should learn it myself but I use it that rarely i'm not sure it's worth it.