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/