VBA toolbar-button programming switch on/off

[Snoopy]

Hey guys
I'm designing this toolbar-button that do some shows/hide-stuff.
So far, my knowlegde of VBA is so limited, that I have used 2 buttons
(imagine that!) - 1 for "show" and 1 for "hide".

I know there is some of You guys out there, smiling and realy enjoying
Your cigars of wisdom - while considering whether to help me or not
(You see?
"Hide" and "Show" again!).
Somehow I just can feel that an answer from outer VBA-space will turn
up through the smoke in any minute - and I will be happyly greatful!


Regards
Snoopy

 

[Norman Jones]

Hi Snoopy,

Try something like:

'=============>>
Private Sub CommandButton1_Click()
Columns(1).Hidden = Not Columns(1).Hidden
End Sub
'<<=============

 

[Snoopy]

Thanks

I think You just solved my problem ))