Thanks Rowan I will try that one
"Rowan" wrote:
For the macro I gave you to work you would need to change to a combobox
from the Control Toolbox.
If you want to stick with the Forms ComboBox then you could use a macro
in a standard module eg:
Sub prtct()
If ActiveSheet.Range("Z1").Value = 1 Then
ActiveSheet.Unprotect Password:="yourpassword"
Cells.Locked = True
ActiveSheet.protect Password:="yourpassword"
End If
End Sub
Where Z1 is the Cell Link for the combobox and Yes is the first option
in the combobox followed by No, and prtct is the macro assigned to the
combobox.
Regards
Rowan
wongard wrote:
The Combo box I am using is from the FORMS Toolbar. should I just change it
to one from the controls toolbox? Would that make things easier?
|