Excell worksheet problem
 

I am having a hard time figuring out how to lock an individual worksheet. I
have a shared workbook that has 5 worksheets that each need to be locked at
various times during the day. How can I lock each individual shared
worksheet and
not affect the others??

Excell worksheet problem
 

Upto my knowledge it is not possible to protect and unprotect the worksheets
when the file is in sharing.

--------------------
(MS-Exl-Learner)
--------------------



"parttimer" wrote:

I am having a hard time figuring out how to lock an individual worksheet. I
have a shared workbook that has 5 worksheets that each need to be locked at
various times during the day. How can I lock each individual shared
worksheet and
not affect the others??

Excell worksheet problem
 

Shared workbooks have a lot of restictions on them. In XL help type in Shared
Workbook Restrictions and select the unavaliable features. You will see that
protection changes among others is not available.

--
HTH...

Jim Thomlinson


"parttimer" wrote:

I am having a hard time figuring out how to lock an individual worksheet. I
have a shared workbook that has 5 worksheets that each need to be locked at
various times during the day. How can I lock each individual shared
worksheet and
not affect the others??