Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking worksheets
I am using Excel 2003 and would like to lock a worksheet, other than a check
box or button, such that the remainder of the sheet cannot be interacted with (but can be viewed) until the check box or button has been clicked. Any help greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking worksheets
Hi,
Maybe something like this would help. It will act as a toggle between being protected and not. Add a button to the sheet and asign it to the macro below. Sub Button1_Click() With ActiveSheet If .ProtectContents = True Then .Unprotect "password" .EnableSelection = xlNoRestrictions Else .Protect "password" .EnableSelection = xlNoSelection End If End With End Sub -- Hope that helps. Vergel Adriano "slim4921" wrote: I am using Excel 2003 and would like to lock a worksheet, other than a check box or button, such that the remainder of the sheet cannot be interacted with (but can be viewed) until the check box or button has been clicked. Any help greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking data between worksheets | Excel Worksheet Functions | |||
Locking Worksheets, Copy and Paste Question | Excel Worksheet Functions | |||
locking and unlocking worksheets | Excel Worksheet Functions | |||
Locking Cells or worksheets | Excel Worksheet Functions | |||
Locking down worksheets | Excel Discussion (Misc queries) |