Hi

..Hidden = False
..Hidden = True

Regards,
Per

"amit" skrev i meddelelsen
...
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?