Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Checkbox to hide and unhide rows Please.
Hello from Steved
Below will hide and unhide columns What is required please to hide and unhide rows Private Sub CheckBox1_Click() Dim r As Range Set r = Range ("D1:E1,G1:H1,J1:K1,M1:N1,P1:Q1,S1:T1,V1:W1,Y1:Z1, AB1:AC1") r.EntireColumn.Hidden = Not r.EntireColumn.Hidden End Sub Thankyou. |
#2
|
|||
|
|||
Hi
replace entirecolumn with entirerow -- Regards Frank Kabel Frankfurt, Germany "Steved" schrieb im Newsbeitrag ... Hello from Steved Below will hide and unhide columns What is required please to hide and unhide rows Private Sub CheckBox1_Click() Dim r As Range Set r = Range ("D1:E1,G1:H1,J1:K1,M1:N1,P1:Q1,S1:T1,V1:W1,Y1:Z1, AB1:AC1") r.EntireColumn.Hidden = Not r.EntireColumn.Hidden End Sub Thankyou. |
#3
|
|||
|
|||
Thankyou.
-----Original Message----- Hi replace entirecolumn with entirerow -- Regards Frank Kabel Frankfurt, Germany "Steved" schrieb im Newsbeitrag ... Hello from Steved Below will hide and unhide columns What is required please to hide and unhide rows Private Sub CheckBox1_Click() Dim r As Range Set r = Range ("D1:E1,G1:H1,J1:K1,M1:N1,P1:Q1,S1:T1,V1:W1,Y1:Z1, AB1:AC1") r.EntireColumn.Hidden = Not r.EntireColumn.Hidden End Sub Thankyou. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I unhide a hiden row | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
I cant hide a workbook | Excel Worksheet Functions | |||
Conditional Hide function for Excel | Excel Worksheet Functions |