Create Menu Screen In Excel

[Lee24]

Hi all, just a quickie but sure someone iwll know what to do....

I have a excel sheet with 12 worksheets within it, i am looking to have a small menu that the user can click on and it takes them straigt to the worksheet.

Any examples would be greatly appreciated.

L

OH YEAH THANKS IN ADVANCE, KEEP THE GOOD WORK UP

 

[SkipVought]

Hi,

You know that you can Right-Click the Sheet Navigation Arrows in the lower LH corner of the Excel Window, to see a popup of all sheets in the workbook.

Other than that, make a list of your sheets and insert a hyperlink.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Lee24]

Nothing more cosmetic than that????

Ta

L

 

[SkipVought]

You can make it as cosmetic as you like.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Lee24]

To be honest I dont know where to start..............

do you have any eXamples?

L

 

[SkipVought]

F1 on HYPERLINK.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[combo]

some cosmetics...

- add autoshape 'bevel'
- format it (no lines, add colour),
- add caption and customise (font size, middle/middle text alignment),
- add hyperlink with screen tip.

Instead of steps 1-2 you can create action button in powerpoint and copy it to excel.

combo