Adding new sheets to a workbook is not supposed to be limited in a
shared workbook (according to the help) but when I try to add a sheet
based on a template using the statement;

Sheets.Add Type:= _
"C:\WINDOWS\Application Data\Microsoft\Templates\Template.xlt"

I get errormessage telling me this opperation is not allowed in a
shared workbook. Am I doing something wrong or is this one of the
things you are not allowed to do if the workbook is shared?

Jon Omar

Does this work if the workbook is not shared?

Regards,
Tom Ogilvy

"Jon Omar" wrote in message
om...
Adding new sheets to a workbook is not supposed to be limited in a
shared workbook (according to the help) but when I try to add a sheet
based on a template using the statement;

Sheets.Add Type:= _
"C:\WINDOWS\Application Data\Microsoft\Templates\Template.xlt"

I get errormessage telling me this opperation is not allowed in a
shared workbook. Am I doing something wrong or is this one of the
things you are not allowed to do if the workbook is shared?

Jon Omar