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
'<<=============


---
Regards,
Norman



"Snoopy" <blaksnm@jjuc.no> wrote in message
news:1144222727.015012.217030@u72g2000cwu.googlegroups.com...
> 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
>
>
>
>

[Snoopy]

Thanks

I think You just solved my problem ))