toggle button to hide columns

[SarahMS1]

i have this toggle button code that hides and unhides for me column E and D but now i want to also hide column P at the same time with them but without hididing the columns between them i just want to hide E,D,P

i use this code but i’m writing this on my phone but just to get an idea

private sub togglebutton_click()
columns (“E:D”) .Hidden = Not Columns (“E:D”) .hidden

thanks!

 

[dmt32]

Hi,

try

Private Sub togglebutton_click()
    Range("E:E,D:D,P:P").EntireColumn.Hidden = Not Range("E:E,D:D,P:P").EntireColumn.Hidden
End Sub

Dave

 

[Yongle]

another one

Private Sub ToggleButton1_Click()
    With Range("D1,E1,P1").EntireColumn
        .Hidden = Not .Hidden
    End With
End Sub

 

[SarahMS1]

Hi,

try

Private Sub togglebutton_click()
    Range("E:E,D:D,P:P").EntireColumn.Hidden = Not Range("E:E,D:D,P:P").EntireColumn.Hidden
End Sub

Dave

Yes thank you so much dave it worked ?

 

[SarahMS1]

another one

Private Sub ToggleButton1_Click()
    With Range("D1,E1,P1").EntireColumn
        .Hidden = Not .Hidden
    End With
End Sub

thank you i appreciate ur help ?