Toolbar buttons to hide/unhide sheets

[Barb in MD]

I originally posted this question under "worksheet functions" but I think
that was the wrong place to post.

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!

 

[Bob Umlas]

Why not customize and reset the toolbars & start over?

 

[Barb in MD]

Thanks, but that's what started this whole problem; I've always customized my
toolbars & one morning my customization had disappeared and I only had the
default toolbars (that was probably something to do with our Citrix servers
at work). It was when I was redoing them that this happened. I've tried
resettting the toolbars again & rebooting and it doesn't help. --
Barb

 

[Gord Dibben]

Go have a look at your original posting in other group.


Gord Dibben MS Excel MVP

 

[Barb in MD]

Got it - thanks so much for your help.
--
Barb

Go have a look at your original posting in other group.


Gord Dibben MS Excel MVP



.

 

[Abdel D]

Barb,
The same thing happened to me, I can't see the hid/unhide from the format menu neither I can find the ico after mistakely dropping it in the outer space. !
Thanks,
Abdel.

 

[Abdel D]

Barb,
The same thing happened to me, I can't see the hide/unhide from the format menu neither I can find the ico after mistakely dropping it in the outer space. !
Thanks,
Abdel.

I originally posted this question under "worksheet functions" but I think
that was the wrong place to post.

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 did not 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 is
nowhere to be found. I have tried moving the toolbars, displaying them on two
rows, and one, and I cannot find where I dropped it. Now I have no toolbar
button, plus, I cannot go back to format, sheet, & click on "hide" because
word "hide" is no longer there. Help!
--
Barb

On Tuesday, February 09, 2010 4:15 PM Bob Umlas wrote:
Why not customize and reset the toolbars & start over?

Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: Excel 2010 - The Missing Manual [OReilly]
http://www.eggheadcafe.com/tutorial...w-excel-2010--the-missing-manual-oreilly.aspx

 

[Abdel D]

Barb,
The same thing happened to me, I can't see the hide/unhide from the format menu neither I can find the ico after mistakely dropping it in the outer space. !
Thanks,
Abdel.

 

[Abdel D]

Barb,
The same thing happened to me, I can't see the hide/unhide from the format menu neither I can find the ico after mistakely dropping it in the outer space. !
Thanks,
Abdel.