ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with loading a template (https://www.excelbanter.com/excel-programming/353068-problem-loading-template.html)

Martien Janssen

Problem with loading a template
 
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







All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com