Command Button to disable VBA code?

Hey everyone,

I have this code set up which basically just hides every other column during printing. I was wondering if there was a way to have a button on the sheet somewhere that when clicked allows this code to be ignored. The columns hidden from the print are just filler data in a sense and it only prints the important columns but some people in the company would like the ability to see all the data and not just the important stuff.

Thanks in advance

Please Login or Register  to view this content.

I'm gonna need a walk through or something with making buttons and how to link them to a command code because I've never made one before.

It's my understanding that "If bHideColumns Then" means that when the button is clicked it hides the columns for printing but how do you actually set up the button. This is my first time using vba so it's been taking me a while to grasp everything.

actually a check box would be perfect if that's easily interchangeable as well