Conditional Cell locking

Steve at work · Jul 24th 2006

I am trying to create a password protected workbook. This workbook has 2 sheets. The first sheet has 3 check boxes. If the first check box is clicked, I want a series of cells in column 5 to unlock on both sheets, and all other cells to remain locked. If check box 2 is ticked, I want column 6 unlocked, and all other cells locked. If check box 3 is ticked, I want column 7 unlocked, and all other cells locked.

Thank you very much in advance for any help you can offer me with this problem.

StefanG · Jul 25th 2006

Re: Conditional Cell locking

Hi Steve at work,
Have you tried the MacroRecorder |Tools |Macro |Record New Macro?
I suppose you could start by recording the three respective steps to
- unprotect your worksheet
(- lock all cells/columns)
- unlock the cells/columns in question for each of the three instances
- protect the worksheet
Stefan

Edit:
p.s.
Another thing to think about would be. Do you want check boxes, so that the user can check 1, 2 or all 3 and hence unlock all one, two or all three ranges at once - well i suppose you can have the respective macro uncheck the respective other box(es)...? - Maybe a radio button, where you could only have one of the three selected ...?

Dave Hawley · Jul 25th 2006

Re: Conditional Cell locking

This should get you started

Code

Private Sub OptionButton1_Click()
    Range("E1,E5,E7:E10").Locked = OptionButton1.Value
End Sub

Conditional Cell locking

Participate now!

Share