Limitations of a shared workbook
 

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

Limitations of a shared workbook
 

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

Limitations of a shared workbook
 

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!