Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Button
I have little knowledge of how to write VB code.
I have a form with 3 option buttons alongside 3 cells for data entry. When a button is selected I want the corresponding cell to allow data entry and the other 2 to be locked. Why does this code not work: Private Sub OptionButton1_Click() Worksheets("PART A").Unprotect Worksheets("PART A").Range(i11).Locked = False Worksheets("PART A").Range("i13:i15,d23:d24").Locked = True Worksheets("PART A").Protect End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
option button-if else? | Excel Programming | |||
Option button | Excel Programming | |||
When using an Option Button can I... | Excel Programming | |||
value of option button | Excel Programming |