Comparative Button

[young engineer]

I am trying to create a button to compare results. I want to have the following columns side by side: F:V, I:U, M:Z, Q:AH, AD:AL when I select the button, and when not selected to return to there normal positions.
I am using excel 2007

pLEASE HELP

 

[SteveO59L]

Couldnt you simply adapt this ?

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

 

[young engineer]

I can adapt the code. How do i attach this to a button

 

[SteveO59L]

How are you creating your button ?

 

[young engineer]

Developer Tab - Design Mode - Insert Activx -Toggle button

Example Code:

Dim bool As Boolean
bool = ToggleButton1.Value
If bool Then
ToggleButton1.Caption = "Show Columns"
Else
ToggleButton1.Caption = "Hide Columns"
End If
Columns("F:F").EntireColumn.Hidden = bool
Columns("g:g").EntireColumn.Hidden = bool
Columns("j:k").EntireColumn.Hidden = bool
Columns("m:n").EntireColumn.Hidden = bool
Columns("p").EntireColumn.Hidden = bool
Columns("q:t").EntireColumn.Hidden = bool
End Sub

 

[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