| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlines and Locked Worksheet: XL97
Hi There,
I have underneath sub to protect my locked cells ... Standing on a locked cell prevents me to use (click) my outlines (XL97!). OK, I understand that it does ...what it does! But maybe there is a workaround? Best Regards Sige Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Locked = True Then Me.Protect Password:="" Else Me.Unprotect Password:="" End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| worksheet protection and outlines | Excel Worksheet Functions | |||
| Protected worksheet and Outlines | Excel Programming | |||
| Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros | Excel Programming | |||
| strange worksheet.codenames in XL97 | Excel Programming | |||
Threaded Mode
