Hiding same Columns using a toggle button over 12 worksheets using VBA code on the toggle button.

[PMRetired2012]

What i want to do is hide the same columns on multiple worksheets using a toggle button. i cant figure out the proper code to attach to the button. i can find code to get it for one worksheet but i have 12 i wnat to hide columns f so i can print with them hidden the toggle the button to put the columns back in.

Thanks

 

[Fluff]

Do you want to hide the column on all sheets or just some?
If just some, how many sheets are there in the workbook?

 

[PMRetired2012]

i wnat hide the column on some sheets.
There are a total of 15 workwheets but i only want to hide columns on 12 of the sheets.
The columns i want to hide are: U:X and AG:AI
Thanks

 

[Fluff]

Ok, how about

Private Sub ToggleButton1_Click()
   Dim ws As Worksheet
   
   For Each ws In Worksheets
      Select Case ws.name
         Case "a", "b", "c"
         Case Else
            With ws.Range("U:X, AG:AI").EntireColumn
               .Hidden = Not .Hidden
            End With
      End Select
   Next ws
End Sub

Change the a,b & c to the names of the sheets that should not be affected.

 

[PMRetired2012]

Fluff i want to say the code you gave me worked correctly.. Thanks
OK i posted another question earlier but didnt get any responce.
What im wanting to do is print in duplex. i am using the syntex (ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)" for the printing now in my macro.
I understand there isnt a option if im using this code to have it print in duplex.
so what kind of code can you give me to print in duplex over 24 pages?
i posted this earlier you might want to go find it and maybe you can answer it if there is a answer.

thanks

 

[Fluff]

Glad to help & thanks for the feedback.

 

[PMRetired2012]

Glad to help & thanks for the feedback.

Fluff, did you see the second part of last message that talked about duplex printing? Can you help me?
i did a seprate post on this and no responces.

Dennis

 

[Fluff]

Yes I did, but cannot help.

 

[PMRetired2012]

Yes I did, but cannot help.

Fluff
Is there anyone you can reach out to that might be able to help me with the duplex printing issue?

Thanks

 

[Fluff]

Nope, I have no idea who might know about that sort of thing.