Worksheet Protection

  • Thread starter Thread starter Patrick Simonds
  • Start date Start date
P

Patrick Simonds

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
 

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

Select statement or me? 12
Worksheet protection 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Lock a control object 2
Multiple Worksheets - Protection 3
How to protect formats in unprotected cells 1
Password Cell Protection 1
Locked cells 1

Back
Top