Locking/Unlocking Sheets for a Shared Workbook while its Shared

[turtlepokerman]

Hello Everyone,

I am trying to setup a shared workbook where each user of the shared workbook will have their own worksheet which they can lock and unlock without unsharing the workbook. Is there anyway to do this in Excel. I need the workbook to be shared so that multiple users can have access to the workbook at the same time.

All help is appreciated.

 

[RoryA]

No, it isn't. You can't alter protection settings in a Shared Workbook. (best to avoid them altogether anyway)