ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Toolbar buttons to hide/unhide sheets (https://www.excelbanter.com/excel-discussion-misc-queries/255826-toolbar-buttons-hide-unhide-sheets.html)

Barb in MD

Toolbar buttons to hide/unhide sheets
 
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!
--
Barb



Bob Umlas[_3_]

Toolbar buttons to hide/unhide sheets
 
Why not customize and reset the toolbars & start over?

"Barb in MD" wrote in message
...
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!
--
Barb



Barb in MD

Toolbar buttons to hide/unhide sheets
 
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


"Bob Umlas" wrote:

Why not customize and reset the toolbars & start over?

"Barb in MD" wrote in message
...
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!
--
Barb


.


Gord Dibben

Toolbar buttons to hide/unhide sheets
 
Go have a look at your original posting in other group.


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 13:12:04 -0800, Barb in MD
wrote:

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!



Barb in MD

Toolbar buttons to hide/unhide sheets
 
Got it - thanks so much for your help.
--
Barb


"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 13:12:04 -0800, Barb in MD
wrote:

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!


.



All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com