View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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