Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide pages
I have a 390 page Excel 2007 spreadsheet. On the first page I have links to
the other 389 pages. On each of those 389 pages is a link back to page 1. Is it possible to make only page 1 visible, yet still be able to get to the rest of the pages from the link on page 1. I tried simply hiding the pages, but then when I click the link on page 1, I can't get to the hidden page. -- bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide pages
Assuming "pages" means "worksheets"..................
There are things you can do with a hidden worksheet like read from or write to but select is not one of them. You will have to add some VBA code to make the sheet visible before you can select it. 390 worksheets sounds like you need a re-think of your workbook. Gord Dibben MS Excel MVP On Thu, 1 Jan 2009 09:54:02 -0800, vdmbqb wrote: I have a 390 page Excel 2007 spreadsheet. On the first page I have links to the other 389 pages. On each of those 389 pages is a link back to page 1. Is it possible to make only page 1 visible, yet still be able to get to the rest of the pages from the link on page 1. I tried simply hiding the pages, but then when I click the link on page 1, I can't get to the hidden page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... | Excel Worksheet Functions | |||
How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) |