Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide unhide rows -Protected sheet
Hello I have a command button in a form
Private Sub CommandButton1_Click() 'hide rows Dim myRng As Range Set myRng = Me.Range("a32:a36") myRng.EntireRow.Hidden = Not (myRng(1).EntireRow.Hidden) but when I protect the form the button does not work. I also have the rows and columns hidden How can I correct this ? thanks End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Using Hide, Unhide, and auto filter - select all on a protected sh | Excel Worksheet Functions | |||
Hide Unhide Rows | Excel Discussion (Misc queries) | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |