Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Unhide Buttons | Excel Discussion (Misc queries) | |||
Macro-Hide & Unhide Sheets with condition | Excel Discussion (Misc queries) | |||
Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
Hide/Unhide Buttons | Excel Discussion (Misc queries) | |||
disable unhide sheets on toolbar | Excel Discussion (Misc queries) |