Can I create a worksheet menu to select each other worksheet

P

pippagrace

I have a multi sheet Workbook and would like to create an initial worksheet
with a menu on it so I can quickly access each of the worksheets I want to
view and avoid those that only have back up data.
 
M

Marcelo

Hi Pippagrace,

Display a pop-up list of sheet names by right-clicking one of the arrows to
the left of the sheet tabs that are located at the bottom of the worksheet
window (see the figure below). Select a sheet from the list, and you're there
in a flash.

Also you could have a lot of information on the Chip Person web page at:

http://www.cpearson.com/excel/sortws.htm

Does this Helps?
Thanks in advance for the feedback
regards from Brazil
Marcelo

"pippagrace" escreveu:
 
P

pippagrace

Many thanks for this - it really helps me with my editing. However what I
would like to know is how do I create one of these quick access menus with
only the sheets that I want to list. I would like to create it on the
Opening page of the Excel document to make the document function well for a
non excel user who will only be viewing.
 
A

Ardus Petus

Have a look at Insert>Hyperlink

HTH
--
AP

pippagrace said:
Many thanks for this - it really helps me with my editing. However what I
would like to know is how do I create one of these quick access menus with
only the sheets that I want to list. I would like to create it on the
Opening page of the Excel document to make the document function well for
a
non excel user who will only be viewing.
Click to expand...
 
Top