Disable Auto_Open in document based on Template

[jlepard]

I created a template with an Auto_Open macro to display UserForm1. Once data is entered, user is prompted to save as a worksheet.

When the worksheet is opened, the Auto_Open macro runs and redisplays the UserForm1. I only want the UserForm to be displayed when the template is selected, not when a worksheet based on the template is opened.

In Word could get around this with the AutoNew macro, but that doesn't exist in Excel.

Any suggestions?

Thanks.

[Juan Pablo González]

In the Auto_Open sub (Altough I REALLY prefer the Workbook_Open event) put something like this:

If ActiveWorkbook.Path = "" then
'Hasn't been saved, show Userform
End If

That, I think, should work.