How to toggle

  • Thread starter Thread starter Cesar Zapata
  • Start date Start date
C

Cesar Zapata

Hi guys,


I have a macro that unhides and hides some columns. I have a button that
toggles the macro depending on the label of the button.

But cause a button takes too much space,( I have other buttons there too) I
would like to know if there is a way to program a combination of keystrokes
to handle my macro. for example CTRL + "-" will hide columns and CTRL + "+"
will unhide them.


thanks/
 
Cesar,

Select the columns, and goto Data>Group And Outline>Group and group these
columns. You then get an outline symbol which allows you to collapse and
expand the hidden columns.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Why not just use the same shortcut with a toggle
Columns("g").EntireColumn.Hidden = _
Not Columns("g").EntireColumn.Hidden
 
Back
Top