column hide/unhide macro

[chiz]

Hi, I have which I hope is a simple problem, any help would be greatly appreciated.

I am trying to hide/unhide several columns by hitting a button. It's a pretty simple macro to do it once, but how do I get a button to hide on the first click, then unhide on the second?

you guys are great, thanks!

[Paul]

Hi Chiz, and welcome to the forum.

How about not hiding & un-hiding based on the # of clicks, rather, based on the current state of those columns. For example:

Please Login or Register  to view this content.

This code sets the value of the Hidden property to its opposite. So if columns A:C are hidden, this code will unhide them; and if they are visible, the code will hide them.

This could be made a little more "basic" by using IF/THEN/ELSE statements, but the Hidden property of a range already returns a TRUE or FALSE value, so it's not needed here.

[chiz]

Oh that is beautiful, thank-you!

Now to push my luck... is there a way to have to change the button text based on the state of the columns?

Specifically, have the macro button display a [+] when the columns are hidden and a [-] when they are visible?

[royUK]

Try this

Please Login or Register  to view this content.