Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Hot Button Lookup | Excel Worksheet Functions | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |