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.

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:

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.

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.

"Marcelo" wrote:

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:

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.

Have a look at InsertHyperlink

HTH
--
AP

"pippagrace" a écrit dans le message
de news: ...
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.

"Marcelo" wrote:

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:

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.

I knew it had to be possible - thank you so much!!!

"Ardus Petus" wrote:

Have a look at InsertHyperlink

HTH
--
AP

"pippagrace" a écrit dans le message
de news: ...
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.

"Marcelo" wrote:

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:

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.