If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! . |
Thread Tools | |
Display Modes | |
|
|