I have a workbook saved as a template (MyWb.xlt). I am using Office 97.
When I use open - new, I can create a new workbook based on this template.
Excel automatically creates a new workbook called MyWb1.xls. Then a dialog
box opens asking whether I want to save the new workbook. If I click on yes,
I can save the workbook but it does save it as a shared workbook, which is
not what I want. I don't understand why Excel does do this ?. MyWb.xlt
contains a number of macros. It also contains an Auto_Open procedure, but
all the things mentioned above happen prior to activating my Auto_Open
procedure.
If I create a simple template worbook without macro's etc., nothing of this
kind happens.

Any idea why the save dialog is triggered and why it saves as a shared
workbook ?

Thanks,

Martien