Detect when template opened as NEW.

Question

I know that when a template xltm file is opened as New, Excel will change the name to template1 and because I have macros defined the file format to xlOpenXMLWorkbookMacroEnabled. I would like to have some VBA macros to do some things when the file is first opened as New template. I know that the Workbook_Open or Auto_open macros run on open, but I can't figure out how to detect if this is the template New Open.

I thought of one of the following would enable me to do this:

1. Is there a built in way to detect when a template *.xltm file is first opened as New?
2. I thought of putting something in a cell in a worksheet and then having the Auto_open or Workbook_Open code change it if the fileformat is not a template. But this seemed like a kludge.

Any other options?

Thanks

John

Answer 1

A saved workbook will have a <br>path.
An unsaved workbook will not.
Check for the path and Exit Sub if<br>path is found.
If not, carry on with workbook_open code.
Private Sub Workbook_Open()
If ActiveWorkbook.Path <> "" Then Exit Sub
'your code here
End Sub

Gord

Answer 2

Perfect!!

Thanks,

John