Button Help

[young engineer]

Hi All
I need to programme a button to show the following columns side by side
F:S, I:V, M:Z, Q:AD, AH:AK. When the button is not selected then the columns should return back to their normal positions. Is it possible to to also have columns F,I,M,Q in one colour and columns S,V,Z,AD,AK in another colour.
How do i go about doing this. Please help

 

[evert]

I need to programme a button to show the following columns side by side
F:S, I:V, M:Z, Q:AD, AH:AK.

That means you want to hide the other columns?

For example, with

Sub Hide()
    Columns("A:E").Hidden = True
End Sub

Sub Unhide()
    Columns("A:E").Hidden = False
End Sub

When the button is not selected...

This is not an event that you can work with.
One moment a button is pressed and less than a second later it is not pressed but what do you want?
You may need a second button for this...

 

[Yard]

Is this not basically the same question as this one:

http://www.mrexcel.com/forum/showthread.php?t=378869

and this one:

http://www.mrexcel.com/forum/showthread.php?t=380220

and this one:

http://www.mrexcel.com/forum/showthread.php?t=380916

 

[jbeaucaire]

You can actually do this with a command button by also changing something in the button itself, like the Caption, and do an IF test on that value. Like this:

Private Sub CommandButton10_Click()
    If CommandButton10.Caption = "HIDE A:E" Then
        CommandButton10.Caption = "SHOW A:E"
        CommandButton10.ForeColor = &HFFFF&
        CommandButton1.ForeColor = &H808080
        Columns("A:E").Hidden = True
    Else: CommandButton10.Caption = "HIDE A:E"
        CommandButton10.ForeColor = &HC0&
        CommandButton1.ForeColor = &H800000
        Columns("A:E").Hidden = False
    End If
End Sub

This dynamically changes the color and the caption so one button does something different each time it is pressed.

 

[Joe4]

Per forum rules, please stick to one thread. The original thread will be left open, but all others will be locked. All follow-ups, bumps, and clarifications should be posted to the original thread.

Original:
http://www.mrexcel.com/forum/showthread.php?t=378869