Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi - I've got a excel sheet which as a bunch of information that i dont want
the user to change and so tried using Protect sheet, however i have a toggle code that is assigned to a object that hides and unhides a set of rows.....this code doesnt seem to run when i have the sheet protected.... Sub SwitchView() With Sheets("Info").Range("62:63").EntireRow ..Hidden = Not .Hidden End With End Sub is there a way to still run this code when the sheet is protected? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock/Unlock cells | Excel Worksheet Functions | |||
lock/unlock cells | Excel Programming | |||
Lock and Unlock Cells | Excel Programming | |||
Lock and Unlock cells using VBA | Excel Discussion (Misc queries) |