Hide and Show Colums using VBA

[Aisha890]

Hi

Can you tell me a VBA Code where I can Hide and Show using a button different columns within a sheet. So as the user presses Hide the columns will be hidden and vice versa for the show.

Regards

[Trebor76]

Hi Aisha890:

Have a look at these:

Please Login or Register  to view this content.

Regards,

Robert

[Aisha890]

Please Login or Register  to view this content.

and for show

Please Login or Register  to view this content.

However it shows the code as in break mode

[Aisha890]

I need a code where in columns K and M wherever there is date. Upon clicking the hide button it will hide and show for the vice versa.

Also when I try to connect it with the button by altering the code from the view code option. It takes me to the code instead of performing the actions. Please tell me how to resolve it.

[Trebor76]

This code will hide your desired columns if they're not hidden or show them if they're hidden:

Please Login or Register  to view this content.

If the code is going into break mode I'm guessing there's a syntax error with it. I've tested mine and there's no issue.

Regards,

Robert