Sorry about the cross post, but I thought I might have placed this message
in the wrong newsgroup category.

I have a work book with over 120 worksheets. Is there any way to set the
worksheet protection on all worksheets so that a user can only select
unlocked cells. I know I can do this by selecting each worksheet, one at a
time, and deselecting all options but "select unlocked cells", but that
will be very time consuming

See answer in other group.

BTW......you did not cross-post..........you multi-posted.


Gord Dibben MS Excel MVP

On Thu, 9 Nov 2006 09:44:45 -0800, "Patrick Simonds"
wrote:

Sorry about the cross post, but I thought I might have placed this message
in the wrong newsgroup category.

I have a work book with over 120 worksheets. Is there any way to set the
worksheet protection on all worksheets so that a user can only select
unlocked cells. I know I can do this by selecting each worksheet, one at a
time, and deselecting all options but "select unlocked cells", but that
will be very time consuming