I have a workbook opens and closes other workbooks so I need to reference the
'master' workbook. However, there are points during code run that the user
can save the file as a different name and I don't want to keep them from
doing that. Problem, they can also change the other workbook names too. For
the other workbooks I don't care if they can or can't change the file name.

Question: What is the easiest way to capture when a user does a save as?
And is there a way to have a msgbox/error box pop up so they know exactly
which workbook they are saving?

I have no control over naming conventions and I have been hit with very
similiar file names which has confused the users.

Problem: I use screenupdating off, so there are a few spots where it looks
like one of the other workbooks is open when it's really the master workbook.