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

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).

--
Regards,
Tom Ogilvy

"Jon Omar" wrote in message
...
Yes



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!