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

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!

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!

.