Limitations of a shared workbook

  • Thread starter Thread starter Jon Omar
  • Start date Start date
J

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