| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
toolbar "button" for hiding/unhiding sheets
I know I can create toolbar " buttons" to hide & unhide sheets by selecting
"add/remove buttons" and then customize, and then clicking on format, sheet, hide, & dragging the word "hide" over to the toolbar. However, when I did this I didn't drop the word "hide" on the toolbar, I missed the toolbar & dropped it off to the side of it, seemingly into outer space because it's nowhere to be found. I've tried moving the toolbars, displaying them on two rows, and one, and I can't find where I dropped it. Now I have no toolbar button, plus, I can't go back to format, sheet, & click on "hide" because word "hide" is no longer there. Help! -- Barb |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
toolbar "button" for hiding/unhiding sheets
ToolsCustomizeToolbarsWorksheet Menu Bar.
Select and "Reset" NOTE: this will wipe out any customizing you have done. Alternative which is non-destructive. ToolsCustomizeCommandsBuilt-in MenusFormat. Drag it to your Worksheet Menu Bar. Remove the existing bad Format menu. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 11:46:06 -0800, Barb in MD wrote: I know I can create toolbar " buttons" to hide & unhide sheets by selecting "add/remove buttons" and then customize, and then clicking on format, sheet, hide, & dragging the word "hide" over to the toolbar. However, when I did this I didn't drop the word "hide" on the toolbar, I missed the toolbar & dropped it off to the side of it, seemingly into outer space because it's nowhere to be found. I've tried moving the toolbars, displaying them on two rows, and one, and I can't find where I dropped it. Now I have no toolbar button, plus, I can't go back to format, sheet, & click on "hide" because word "hide" is no longer there. Help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
toolbar "button" for hiding/unhiding sheets
Wonderful! Thank you.
-- Barb "Gord Dibben" wrote: ToolsCustomizeToolbarsWorksheet Menu Bar. Select and "Reset" NOTE: this will wipe out any customizing you have done. Alternative which is non-destructive. ToolsCustomizeCommandsBuilt-in MenusFormat. Drag it to your Worksheet Menu Bar. Remove the existing bad Format menu. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 11:46:06 -0800, Barb in MD wrote: I know I can create toolbar " buttons" to hide & unhide sheets by selecting "add/remove buttons" and then customize, and then clicking on format, sheet, hide, & dragging the word "hide" over to the toolbar. However, when I did this I didn't drop the word "hide" on the toolbar, I missed the toolbar & dropped it off to the side of it, seemingly into outer space because it's nowhere to be found. I've tried moving the toolbars, displaying them on two rows, and one, and I can't find where I dropped it. Now I have no toolbar button, plus, I can't go back to format, sheet, & click on "hide" because word "hide" is no longer there. Help! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diff. change headline in "Formatting" or "Outlining" toolbar? | Excel Discussion (Misc queries) | |||
| "Form / Button" Macro for Unhiding Sheets | Excel Discussion (Misc queries) | |||
| Add "Equation 3.0" button to Excel toolbar. | Setting up and Configuration of Excel | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
