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 DataGroup And OutlineGroup 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)

"Cesar Zapata" wrote in message
...
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

See Application.OnKey in VBA Help.

HTH
Anders Silvén


"Cesar Zapata" skrev i meddelandet ...
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/

Why not just use the same shortcut with a toggle
Columns("g").EntireColumn.Hidden = _
Not Columns("g").EntireColumn.Hidden

--
Don Guillett
SalesAid Software

"Cesar Zapata" wrote in message
...
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/