| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect worksheet with check box
Hello
I added a check box using the control tool box. Then in the sheet code I added the following Private Sub CheckBox1_Click() Rows("1:68").Select ActiveSheet.Protect "pass" ActiveSheet.Unprotect "pass" End Sub This is what Im trying to do when the check box is selected or checked then rows 1 thru 68 will be protected else if the checked box is uncheck sheet is unprotected thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protect worksheet with check box | Excel Discussion (Misc queries) | |||
| Can I change default check boxes on protect sheet? | Excel Discussion (Misc queries) | |||
| How do I copy a check box result from Worksheet A to Worksheet B? | Excel Worksheet Functions | |||
| How can I protect a worksheet but still use ActiveX check-boxes? | Excel Discussion (Misc queries) | |||
| How can I protect a cell and keep the spell check working? | Excel Discussion (Misc queries) | |||
Linear Mode
