Run Two Macros from Same Button

[Guest]

I've searched the archives here but have not found a suitable answer for this.
I want to be able to execute two commands from the same button.
When the button is pressed once Columns B are hidden and when the button
is pressed again Columns B are unhidden.

Here's the basic macro I've recorded.

Columns("B").Select
Selection.EntireColumn.Hidden = True
End Sub

Columns("B").Select
Selection.EntireColumn.Hidden = False
End Sub

Any help would be much appreciated.

Thank you.

 

[Guest]

The whole thing can be cone with this one line of code...

Columns("B").EntireColumn.Hidden = Not Columns("B").EntireColumn.Hidden

 

[Chip Pearson]

You need only a single procedure.

Sub SwitchView()
With ActiveSheet.Range("B").EntireColumn
.Hidden = Not .Hidden
End With
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

Thank you, Jim. It works perfectly. And I'm using it in another workbook as
well!
Regards,
Exceller

 

[Guest]

Holy crap--the legend himself--it's ExcElvis--I'm honored! Thanks for the
code.
I've turned on probably 100 of my colleagues to your Excel page. It's the
first resource I turn to for formula/function examples and ideas.
Thanks!
Exceller

 

[Chip Pearson]

it's ExcElvis--

That's good. I laughed out loud when I read that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

That's you, dude. That's what I call you around here.
When my MBA/CPA boss comes to me with an Excel problem (because he knows
less about Excel than my 8 year old) I say "what does ExcElvis have to say
about this..." I go to www.cpearson.com and BINGO! It's there.
If it weren't for you, everyone around here would know I'm incompetent.
Have a good one.
Exceller