excell
 

is there a way of setting up a front page with buttons that will allow me to
open pages within a work sheet

Yes..........start with Sheet 1, rename it to something like "MainMenu" and
create some drawing objects, squares circles, etc on it and then record
macros to switch to the sheets desired and then assign those macros to the
drawing objects.......you also might want to add a "Return to Main Menu"
button on each sheet.

Vaya con Dios,
Chuck, CABGx3



"bogwald" wrote in message
...
is there a way of setting up a front page with buttons that will allow me
to
open pages within a work sheet

You could just right-click on the "VCR" buttons at the bottom left corner
(just to the left of the Sheet tabs) to get a pop-up for easy one-click
navigation to the sheets. And if there's a whole lot of sheets, there'll be
a scrollable dialog for easy selection.

Think Jim Cone also has an add-in (XLExtras Release 117 - latest ?) -
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, try one of Jim's posts at: http://tinyurl.com/67sx2
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"bogwald" wrote in message
...
is there a way of setting up a front page with buttons that will allow me
to
open pages within a work sheet

How about a front page with hyperlinks to go where you wish?

Use a large font size and descriptive names for each hyperlink.


Gord Dibben Excel MVP

On Mon, 7 Mar 2005 17:09:11 -0800, "bogwald"
wrote:

is there a way of setting up a front page with buttons that will allow me to
open pages within a work sheet