How do I set up an index page that opens other wkshts?

A

Amie

Hi there!

I need to set up an index page that will open other pages when a button is
selected. How do I create this??
 
P

Peo Sjoblom

One way:
Open the index sheet, record a macro when you select another sheet or open
another workbook,
Put a command button from the forms toolbar on your index sheet
(view>toolbars>form), drag a command button to where you want it, when you
release the mouse up pops a window where you can select your recorded macro
 
M

Max

Sounds like you're setting up a Table of Contents? Think Jim Cone has an
add-in (XLExtras), available upon direct request, which provides excellent
capabilities to easily insert / create a Table Of Contents (including
navigating to chartsheets) amongst its many features ..

For details, you might want to check out one of Jim's posts at:
http://tinyurl.com/67sx2
 
M

mac@bath

By "pages" do you mean "worksheets"???
I've found that the "hyperlink" option works perfectly - you can even jump
straight to a particular cell within any worksheet.
If you really DO mean pages (within a large spreadsheet over multiple pages)
then you can also hyperlink to a 'cell' at the top-right of that particualr
page.
 
Top