Using VBA with Shared Workbooks

[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?

 

[Dave Peterson]

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.