Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect object vs. Protection from menu
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I protect an object in worksheets? | Excel Discussion (Misc queries) | |||
Protect Only an Object on a Worksheet | Excel Discussion (Misc queries) | |||
List Object and Protection | Excel Worksheet Functions | |||
protect embeded object | Excel Discussion (Misc queries) | |||
protect embeded object | Excel Worksheet Functions |