Using VBA with Shared Workbooks

  • Thread starter Thread starter Brandenkopf
  • Start date Start date
B

Brandenkopf

Being new to shared workbooks, I am quickly learning about their
limitations. I am wondering if anybody has been successful at
overcoming some of them.

In using the original (un-shared) workbook application my code
un-protects some worksheets during data processing, and then protects
them in the background, before the user can continue. This seems to be
impossible once the workbook is shared. If I build in the code to
un-share the workbook, the file gets saved and the workbook is no
longer shared. This takes too long and compromises the notion of
sharing a workbook.

It is so simple to do this on a single workbook basis. Is there a
seamless way to protect and unprotect worksheets via code with a shared
workbook?
 
I don't think that you can unprotect/protect a worksheet in a shared workbook:

From xl2002's help: Features that are unavailable in shared workbooks

Unavailable feature: Protect or unprotect worksheets or the workbook
Alternative: Existing protection remains in effect.
 
Back
Top