Hide and unhide columns in excel with toggle button

Hi,

I am trying to hide and unhide several columns and all of them are not adjacent to each other. I made this code (see below) work for column F to I, and I have also tried to use the "Range" for several (not adjacent) columns and it worked, but when pressing the toggle button they did not appear again. How do I implement the "Range" command to work with this code? Or is there any other code i can use to make it work? I need to hide and unhide with one toggle button columns F to I, O to V and X.

Please Login or Register  to view this content.

Thanks for your time if you are able to help. It is much appreciated.

Hi @MetteKvidal. Try.

This worked perfect, but for the next step I wanted to use several toggle buttons in the same excel sheet. Tried to add another toggle button and address this with same code, and only replaced columns I wanted to hide, but this doen't work. Only the toggle button 1 works. Is there a work around to make this work? (I made sure to add the same code to button 2 btw.)

Thanks again for your help :D

*Blush* No, I didn't. It works! Thanks a lot <3