I have just made this posting elsewhe-

In Sheet1 cell A 6 type:-

=Sheet3!A6

In the same cell (Sheet1 cell A6)

- right hand click once

- click on Hyperlink

- Insert Hyperlink should launch

- select Place in This Document (by clicking it) on the left hand side

- in the Type the cell reference: box (field) on the right hand side select
A6

- select Sheet3 (for example) on the right hand side (by clicking on that
option)

- click OK

- Sheet1 cell A 6 will now change format to show that a hyperlink has been
added

- Save the file (if required)

Clicking in Sheet1 cell A6 will now take you to Sheet3 cell A6 automatically.

A QUICK reaction to what you have posted is that it, "looks do-able". Create
hyperlinks as above.

If my comments have helped please hit Yes.

Thanks!





"Staying Productive" wrote:

I want to be able to create a shortcut icon to each individual sheet inside
of one workbook. Is this possible?

I am aware that there are macros that you can use inside of Excel to make
the workbook always open to a specific sheet, but this is not exactly what I
am trying to do. I have multiple open jobs at any given time, and I keep
information on these jobs in one Workbook. Each job has its own folder on
the hard drive. I would like to create a shortcut inside of each folder on
the hard drive that opens the same Workbook, but opens it directly to the
sheet that corresponds to the job folder in which the shortcut is located. I
feel as if there should be some parameters that I can set inside of the
shortcut icon to direct me to a specific workbook and a specific sheet inside
of the workbook, but I'm unable to figure this out. Any help would be
greatly appreciated. Thanks in advance