G'day,
I have a template that I want to be able to open a different userform
depending on the type of document, e.g. when I open the template I want
userform1 to open, when I create a new spreadsheet based on the template, I
want userform2 to open.

Is there anyway that I can do this?

I have tried using an auto open macro (MS Office 2000), to detect the
filename (ie filename.xlt or newfile1.xls) but this doesn't work.

Any suggestions?

Thanks,