Excell worksheet problem

  • Thread starter Thread starter parttimer
  • Start date Start date
P

parttimer

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??
 
Upto my knowledge it is not possible to protect and unprotect the worksheets
when the file is in sharing.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

locking a shared worksheet 2
Lookup on worksheet 1
Signature locking entire workbook 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
corrupted formula in protected worksheet 21
When sharing, can I force an Excel document to open in a certain view? 0
Average Multiple Worksheets without blanks or zeros 2
Unprotecting worksheets 2

Back
Top