Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Unhide Buttons Microsoft Communities[_2_] Excel Discussion (Misc queries) 4 December 26th 09 03:18 PM
Macro-Hide & Unhide Sheets with condition [email protected] Excel Discussion (Misc queries) 8 August 22nd 07 02:04 AM
Hide or unhide sheets based on cell billinr Excel Discussion (Misc queries) 2 July 13th 07 07:42 PM
Hide/Unhide Buttons kdog Excel Discussion (Misc queries) 2 October 12th 06 07:38 PM
disable unhide sheets on toolbar ditchy Excel Discussion (Misc queries) 8 May 4th 05 10:10 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"