Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I
missing something? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Hi,
If you right click on a tab you have the option to either hide or unhide. Selecting HIDE will hide that sheet or selecting UNHIDE will show all the hidden sheets HTH Thanks, SImon Smibes wrote: I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Thanks simon however it did not answer the question. I want to hide or unhide
all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John "smw226 via OfficeKB.com" wrote: Hi, If you right click on a tab you have the option to either hide or unhide. Selecting HIDE will hide that sheet or selecting UNHIDE will show all the hidden sheets HTH Thanks, SImon Smibes wrote: I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Hi John,
From what I can see there is no option to hide the sheet tabs and there is also no reference to them in the help...which doesn't look promicing. However, it is possible to resize the horizontal slider to cover them. I know this is not the ideal solution but at least it hides them Thanks, Simon Smibes wrote: Thanks simon however it did not answer the question. I want to hide or unhide all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John Hi, [quoted text clipped - 11 lines] I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Thanks Simon, Unfortunately it doesn't help. We provide a number of
products (Methodologies) to our clients on Excel and we always ship them with Sheet Tabs hidden because we provide our own menu system. None of these workbooks will migrate to Excel 2007 because of the lack of this feature. This seems like a significant oversite by the 2007 developers. Cheers, John "smw226 via OfficeKB.com" wrote: Hi John, From what I can see there is no option to hide the sheet tabs and there is also no reference to them in the help...which doesn't look promicing. However, it is possible to resize the horizontal slider to cover them. I know this is not the ideal solution but at least it hides them Thanks, Simon Smibes wrote: Thanks simon however it did not answer the question. I want to hide or unhide all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John Hi, [quoted text clipped - 11 lines] I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Dear Smibes,
Not sure if my replies hurt your feeling about the hide/unhide comments. I used to make a copy of the excel file and paste it to another file/work sheet. Then, every column/row hiden will be appeared on the new work sheet. Not sure if this could be the same for the hide/unhide work sheets. ^_^..... It's surely sort of bugs in Excel and everybody believes to hide column/rows and put an code will protect the unseen information. Check it yourself might be better. I never try to hide work sheet!! ** USED TO BE TOP SCRECT IN MY MIND.** So, I, myself, when I send some xls file to customers, it was strickly re-edit by copy 1st paste special with "value" 2nd past special with "format" delete all the unecessary information to customers. By this way, I can hide all the connection or formula in front of my customers. And, making sure there's no unecessary informaiton exposed to customers. "Smibes" wrote: Thanks Simon, Unfortunately it doesn't help. We provide a number of products (Methodologies) to our clients on Excel and we always ship them with Sheet Tabs hidden because we provide our own menu system. None of these workbooks will migrate to Excel 2007 because of the lack of this feature. This seems like a significant oversite by the 2007 developers. Cheers, John "smw226 via OfficeKB.com" wrote: Hi John, From what I can see there is no option to hide the sheet tabs and there is also no reference to them in the help...which doesn't look promicing. However, it is possible to resize the horizontal slider to cover them. I know this is not the ideal solution but at least it hides them Thanks, Simon Smibes wrote: Thanks simon however it did not answer the question. I want to hide or unhide all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John Hi, [quoted text clipped - 11 lines] I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Thanks skywonder97,
I don't think what you suggested will help. We need our users to move from sheet to sheet in a sequence that we will determine based on their data input. We don't want them going to any sheet in any sequence by clicking on the sheet tabs. That is why we need to hide the sheet tabs Cheers, Smibes "skywonder97" wrote: Dear Smibes, Not sure if my replies hurt your feeling about the hide/unhide comments. I used to make a copy of the excel file and paste it to another file/work sheet. Then, every column/row hiden will be appeared on the new work sheet. Not sure if this could be the same for the hide/unhide work sheets. ^_^..... It's surely sort of bugs in Excel and everybody believes to hide column/rows and put an code will protect the unseen information. Check it yourself might be better. I never try to hide work sheet!! ** USED TO BE TOP SCRECT IN MY MIND.** So, I, myself, when I send some xls file to customers, it was strickly re-edit by copy 1st paste special with "value" 2nd past special with "format" delete all the unecessary information to customers. By this way, I can hide all the connection or formula in front of my customers. And, making sure there's no unecessary informaiton exposed to customers. "Smibes" wrote: Thanks Simon, Unfortunately it doesn't help. We provide a number of products (Methodologies) to our clients on Excel and we always ship them with Sheet Tabs hidden because we provide our own menu system. None of these workbooks will migrate to Excel 2007 because of the lack of this feature. This seems like a significant oversite by the 2007 developers. Cheers, John "smw226 via OfficeKB.com" wrote: Hi John, From what I can see there is no option to hide the sheet tabs and there is also no reference to them in the help...which doesn't look promicing. However, it is possible to resize the horizontal slider to cover them. I know this is not the ideal solution but at least it hides them Thanks, Simon Smibes wrote: Thanks simon however it did not answer the question. I want to hide or unhide all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John Hi, [quoted text clipped - 11 lines] I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Connection(links to another excel file/single sheet) in cells might be help!
"Smibes" wrote: Thanks skywonder97, I don't think what you suggested will help. We need our users to move from sheet to sheet in a sequence that we will determine based on their data input. We don't want them going to any sheet in any sequence by clicking on the sheet tabs. That is why we need to hide the sheet tabs Cheers, Smibes "skywonder97" wrote: Dear Smibes, Not sure if my replies hurt your feeling about the hide/unhide comments. I used to make a copy of the excel file and paste it to another file/work sheet. Then, every column/row hiden will be appeared on the new work sheet. Not sure if this could be the same for the hide/unhide work sheets. ^_^..... It's surely sort of bugs in Excel and everybody believes to hide column/rows and put an code will protect the unseen information. Check it yourself might be better. I never try to hide work sheet!! ** USED TO BE TOP SCRECT IN MY MIND.** So, I, myself, when I send some xls file to customers, it was strickly re-edit by copy 1st paste special with "value" 2nd past special with "format" delete all the unecessary information to customers. By this way, I can hide all the connection or formula in front of my customers. And, making sure there's no unecessary informaiton exposed to customers. "Smibes" wrote: Thanks Simon, Unfortunately it doesn't help. We provide a number of products (Methodologies) to our clients on Excel and we always ship them with Sheet Tabs hidden because we provide our own menu system. None of these workbooks will migrate to Excel 2007 because of the lack of this feature. This seems like a significant oversite by the 2007 developers. Cheers, John "smw226 via OfficeKB.com" wrote: Hi John, From what I can see there is no option to hide the sheet tabs and there is also no reference to them in the help...which doesn't look promicing. However, it is possible to resize the horizontal slider to cover them. I know this is not the ideal solution but at least it hides them Thanks, Simon Smibes wrote: Thanks simon however it did not answer the question. I want to hide or unhide all sheet tabs (not the individual sheets). In 2003 this was a Sheet Tabs checkbox in "Tools/options/view/window options". This would hide/unhide sheet tabs. I cannot find the equivalent in 2007. Thanks, John Hi, [quoted text clipped - 11 lines] I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
I also cannot find out within the user interface how to do this, but have got
around the problem by using the statement: ActiveWindow.DisplayWorkbookTabs = False within VBA. This will then hide the sheet tabs, setting to True will display them. Hope this helps. "Smibes" wrote: I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide/unhide sheet Tabs in Excel 2007?
Hi John
Office button Excel options Advanced -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JohnUK" wrote in message ... I also cannot find out within the user interface how to do this, but have got around the problem by using the statement: ActiveWindow.DisplayWorkbookTabs = False within VBA. This will then hide the sheet tabs, setting to True will display them. Hope this helps. "Smibes" wrote: I cannot find how to hide or unhide sheet tabs in Excel 2007 beta. Am I missing something? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide or show all sheet tabs
Click on the Office Button (top Left)
Select Excel Options at the bottom of the window Click Advanced Scroll down to "Display options for this workbook" Check or uncheck "Show sheet tabs" box. Enjoy EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from one excel sheet into poreset tabs? | Excel Discussion (Misc queries) | |||
How do I change the Excel sheet tab bar to display more sheet tabs | Excel Discussion (Misc queries) | |||
Code to create tabs in single excel sheet | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
is there anyway in an excel macro to reorder the sheet tabs from left to right? | Excel Worksheet Functions |