I want to have a macro that is utilised when my workbook is opened. What I
need it to do is, look at the current filename, if it is still the same as
the template filename, then bring up a message box that will have the option
of going to the save as.. function, or clicking cancel will just open the
book as normal.

If however, the name has changed from the original title, then it will just
load up without having a message box.

Any help will be greatly appreciated.