Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tabs for just some sheets.
Hi,
how would I hid some worksheet tabs but not others. I have about 12 main tabs that I need to show for navigatio purposes. Then I will have 80 subsiduary sheets that I want to navigate to from a `masterpage` using hyperlinks. Having played about with this a bit, the problem is that when I navigate to lets say subsiduary sheet 20 from the master sheet, the tabs scroll across the bottom and now I can`t easily get back to my first and most important worksheet pages. I have to rescroll back left to get them in view again. Any ideas people? Many hanks. RR1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tabs for just some sheets.
I would suggest making a custom toolbar for the workbook, with buttons that
select your "main sheets". Each button would then have a short macro attached to it. Check out this link: http://www.contextures.com/xlToolbar02.html For guidance on making a custom toolbar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Romileyrunner1" wrote: Hi, how would I hid some worksheet tabs but not others. I have about 12 main tabs that I need to show for navigatio purposes. Then I will have 80 subsiduary sheets that I want to navigate to from a `masterpage` using hyperlinks. Having played about with this a bit, the problem is that when I navigate to lets say subsiduary sheet 20 from the master sheet, the tabs scroll across the bottom and now I can`t easily get back to my first and most important worksheet pages. I have to rescroll back left to get them in view again. Any ideas people? Many hanks. RR1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tabs for just some sheets.
Thanks Luke, I`ll give it a go.
RR1 I`ll get back once I`ve given it a try. (may be some time!!!!!!!!!) "Luke M" wrote: I would suggest making a custom toolbar for the workbook, with buttons that select your "main sheets". Each button would then have a short macro attached to it. Check out this link: http://www.contextures.com/xlToolbar02.html For guidance on making a custom toolbar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Romileyrunner1" wrote: Hi, how would I hid some worksheet tabs but not others. I have about 12 main tabs that I need to show for navigatio purposes. Then I will have 80 subsiduary sheets that I want to navigate to from a `masterpage` using hyperlinks. Having played about with this a bit, the problem is that when I navigate to lets say subsiduary sheet 20 from the master sheet, the tabs scroll across the bottom and now I can`t easily get back to my first and most important worksheet pages. I have to rescroll back left to get them in view again. Any ideas people? Many hanks. RR1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tabs for just some sheets.
You can build a Sheet Navigation Toolbar as per Dave Peterson's code on
Debra Dalgleish's site. Sorts as well as navigates. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Tue, 8 Sep 2009 12:37:44 -0700, Romileyrunner1 wrote: Hi, how would I hid some worksheet tabs but not others. I have about 12 main tabs that I need to show for navigatio purposes. Then I will have 80 subsiduary sheets that I want to navigate to from a `masterpage` using hyperlinks. Having played about with this a bit, the problem is that when I navigate to lets say subsiduary sheet 20 from the master sheet, the tabs scroll across the bottom and now I can`t easily get back to my first and most important worksheet pages. I have to rescroll back left to get them in view again. Any ideas people? Many hanks. RR1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tabs for just some sheets.
Hi,
After getting to the 20th sheet, you can right click on the "VCR" controls which appear at the bottom left and then select the last option. This will bring up the activate box and you can now jump to a specific sheet by selecting it. You may also refer to http://www.merawindows.com/Forums/ta...s/Default.aspx Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Romileyrunner1" wrote in message ... Hi, how would I hid some worksheet tabs but not others. I have about 12 main tabs that I need to show for navigatio purposes. Then I will have 80 subsiduary sheets that I want to navigate to from a `masterpage` using hyperlinks. Having played about with this a bit, the problem is that when I navigate to lets say subsiduary sheet 20 from the master sheet, the tabs scroll across the bottom and now I can`t easily get back to my first and most important worksheet pages. I have to rescroll back left to get them in view again. Any ideas people? Many hanks. RR1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Tabs | Excel Discussion (Misc queries) | |||
hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
Hiding Rows & Tabs at the same time | Excel Discussion (Misc queries) | |||
Locking Sheets / Hiding Sheets | Excel Worksheet Functions | |||
Hiding Sheets | Excel Worksheet Functions |