Worksheet Protection
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
|