setting Select (Un)Locked Cells in Worksheet Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot find a way in VBA for accessing the Select Unlocked Cells or Select
Locked Cells properties that appear on the list of allowed actions of the
Protection dialog in Excel XP. Most of the other properties listed there seem
to available with Protect. Does anyone know a way?

(Does anyone else find the XP VBA help for Excel as annoying as I do? Many
lists of xl constants and properties and/or their definitions appear to be
missing or so well hidden I can't find them.)

Thanks!!!
 
You must log in or register to reply here.

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

Password Cell Protection 1
Select statement or me? 12
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Allow VBA code to change a locked cell?? 2
VBA Protect and NOT be able to selct locked cells 2
Worksheet Protection Question 1
Not Select locked cells 0
best way protect unprotected cells 2

Back
Top