Using VBA with Shared Workbooks
 

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?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Using VBA with Shared Workbooks
 

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 featu Protect or unprotect worksheets or the workbook
Alternative: Existing protection remains in effect.



Brandenkopf wrote:

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?

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson