royUK and jiuk,
Thank you both for the replies.
The way we use the program at work, the consensus was to have it pop-up on any Save. I think we just got used to it. I may try to code something that saves a temporary copy somewhere but I just hate forcing people use a location I choose for them, but I also want to try to protect them from overwriting their 'Master', especially if I'm not around to give them a fresh copy. My skills, and time, aren't up to the task to do much more though.
Thanks for the other codes, I will incorporate them in my 'project', they will be very useful I think. However, I still can't save the Excel without it crashing on the first SaveAs. It's really strange, especially hearing that royUK had no issues. Makes me think there is something else hiding on me that I need to find and it might not necessarily be the code.
It is frustrating though when for the past 8 months it has worked a charm and now it is cumbersome, to say the least, to use.