Limitations of a shared workbook

[Jon Omar]

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

 

[Tom Ogilvy]

Does this work if the workbook is not shared?

Regards,
Tom Ogilvy

 

[Tom Ogilvy]

Then I would have to guess that it is not allowed when the workbook is
shared - whether advertised or not - the error message appears to rule in
this case. You might pursue a workaround such as opening the template and
copying the sheet from the template (if that is allowed).