Protect object vs. Protection from menu

Protect object vs. Protection from menu

Post by newbi » Fri, 13 Aug 2004 00:00:20


Hello all,
When protecting a worksheet from Excel's [Tools =>
Protection] menu I have the option of selecting
the "Select locked cells" & "Select unlocked cells"
checkboxes. However, the protect object in VBA doesn't
seem to provide this functionality, (it only provides the
parameters for the other items in the dialog box). Could
someone tell me how this same functionality is achieved
through VBA? I am looking to create a completely read-
only sheet which can be changed and re-formatted from
another sheet. I am currently unprotecting the sheet,
making my formatting changes, and then re-protecting the
sheet. If I protect the sheet from the menu and un-select
the first two boxes, I acheive the desired result. But
If I protect from VBA I can still select the cell on the
protected sheet, (but obviously I can't change them).
Any help anyone can provide would be extremely
appreciated.
Thank you.
 
 
 

Protect object vs. Protection from menu

Post by Willia » Fri, 13 Aug 2004 00:13:37

Hi

Try unprotecting the worksheet and then experiment with each of the 3
alternatives below prior to reprotecting the sheet....

ActiveSheet.EnableSelection = xlNoRestrictions
ActiveSheet.EnableSelection = xlUnlockedCells
ActiveSheet.EnableSelection = xlNoSelection

--
XL2002
Regards

William

XXXX@XXXXX.COM



| Hello all,
| When protecting a worksheet from Excel's [Tools =>
| Protection] menu I have the option of selecting
| the "Select locked cells" & "Select unlocked cells"
| checkboxes. However, the protect object in VBA doesn't
| seem to provide this functionality, (it only provides the
| parameters for the other items in the dialog box). Could
| someone tell me how this same functionality is achieved
| through VBA? I am looking to create a completely read-
| only sheet which can be changed and re-formatted from
| another sheet. I am currently unprotecting the sheet,
| making my formatting changes, and then re-protecting the
| sheet. If I protect the sheet from the menu and un-select
| the first two boxes, I acheive the desired result. But
| If I protect from VBA I can still select the cell on the
| protected sheet, (but obviously I can't change them).
| Any help anyone can provide would be extremely
| appreciated.
| Thank you.