Button hides unhides columns, how?
 

I inherited a workbook where in some tabs buttons are used to hide and unhide
columns. These buttons appear above the column headers and are labeled with
the + sign. When clicked several columns are unhidden and a button appears
with a "-" sign. Clicking this button in turn rehides the columns. How is
this done? Are these command buttons? How are they inserted above the
column headers? I've not been able to figure out how to see the code behind
the buttons. Any guidance will be greatly appreciated.
--
JimH

check in Help for Group and UnGroup. This is an option accessible off the
Data menu


"JimH" wrote:

I inherited a workbook where in some tabs buttons are used to hide and unhide
columns. These buttons appear above the column headers and are labeled with
the + sign. When clicked several columns are unhidden and a button appears
with a "-" sign. Clicking this button in turn rehides the columns. How is
this done? Are these command buttons? How are they inserted above the
column headers? I've not been able to figure out how to see the code behind
the buttons. Any guidance will be greatly appreciated.
--
JimH

Thank you. So easy when you know. Works like a charm.

"Duke Carey" wrote:

check in Help for Group and UnGroup. This is an option accessible off the
Data menu


"JimH" wrote:

I inherited a workbook where in some tabs buttons are used to hide and unhide
columns. These buttons appear above the column headers and are labeled with
the + sign. When clicked several columns are unhidden and a button appears
with a "-" sign. Clicking this button in turn rehides the columns. How is
this done? Are these command buttons? How are they inserted above the
column headers? I've not been able to figure out how to see the code behind
the buttons. Any guidance will be greatly appreciated.
--
JimH

Try this for example:

Create a Macro with the following (probably a little unorthodox, but it
works)


Sub HideUnhideSheet()
If Sheets("Sheet2").Visible = False Then GoTo FalseHide Else GoTo
TrueUnhide

FalseHide:
Sheets("Sheet2").Visible = True
Sheets("Sheet2").Activate
End

TrueUnhide:
Sheets("Sheet2").Visible = False
Sheets(1).Activate

End Sub


Then:
Goto View-Toolbars-Customize
Click 'New'
Give your new Toolbar a name and click OK
With your new Customer Toolbar highlighted, click the Commands tab.
Scroll down and select, say, 'Macros' and then drag the Custom Button face
to your new Toolbar.
Then right-click on your new Toolbar button and select 'Assign Macro'.
Select the Macro that you just created and click OK.
Click Close on the Customize window.
You may have to exit Design Mode at this point.
Your button is now created and ready to use.

I'm sure there are other ways of doing this, but this works.



"JimH" wrote in message
...
I inherited a workbook where in some tabs buttons are used to hide and
unhide
columns. These buttons appear above the column headers and are labeled
with
the + sign. When clicked several columns are unhidden and a button
appears
with a "-" sign. Clicking this button in turn rehides the columns. How
is
this done? Are these command buttons? How are they inserted above the
column headers? I've not been able to figure out how to see the code
behind
the buttons. Any guidance will be greatly appreciated.
--
JimH