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
 
Does this work if the workbook is not shared?

Regards,
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
delete sheet in shared workbook 6
Sharing workbook removes cell protection 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Automatically Adding a Worksheet 14
Shared Workbook Crash 0
Sharing Macros 1
Macro can not unprotect a sheet in a shared workbook 4

Back
Top