I am having a hard time figuring out how to lock an individual worksheet. I
have a 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??

Please check the answers to your previous post... FYI multi posting is
considered poor form.

Also the answer is you can not change protection in a shared workbook. There
are lots of restritictions with no satisfactory work around and that is one
of them...
--
HTH...

Jim Thomlinson


"parttimer" wrote:

I am having a hard time figuring out how to lock an individual worksheet. I
have a 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??