hide pages

[vdmbqb]

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.

 

[Gord Dibben]

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