I have a template file that has a macro that runs on Private Sub
Workbook_Open() in the "ThisWorkbook". the macro triggers other routines to
find a file and copy it's contents to a particualr sheet etc. This works fine
on opeinng the Template file

I have a button assigned to a macro that will reopen the Template file if
the user wants to restart the routine. I get the usual message that
reopeinng the file will cause any changes you made to be disregarded...etc.
However, when the file is opened Private Sub Workbook_Open() doesn't run.

Any ideas?