That looks like a solution. I'll give it a try. Thanks!

"Dave Peterson" wrote:

If it's a real template that's creating a new workbook, you could use:

Option Explicit
sub auto_open()
if thisworkbook.path = "" then
'never been saved
'show userform
else
'it's not a template anymore
'do nothing
end if
end sub

Steve C wrote:

I created a template with an opening form launched by an Auto_Open macro.
Once a new spreadsheet is created and saved, I would like the form to be
supressed when the workbook is subsequently re-opened. Is there a way to do
this with an Auto_Close macro? Thanks.

Steve C

--

Dave Peterson