Using a Windows Shortcut to Open to Specific Sheet in Workbook

[Staying Productive]

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

 

[trip_to_tokyo]

I have just made this posting elsewhere:-

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!

 

[trip_to_tokyo]

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

Yes: create hyperlinks on one Worksheet to look at other Worksheets within
the same Workbook.

If my comments have helped please hit Yes.

Thanks.

 

[Staying Productive]

thanks for the response, but after reading your response I feel as if I
haven't been clear in my question.

Your method requires me to be inside of the workbook itself. I am trying to
use a Windows Shortcut Icon to open a workbook to a specific sheet inside of
the workbook, instead of just the specific workbook itself.

EXAMPLE: Workbook named "Master"
Sheets named "A" "B" "C" "D"

I would like to create four different shortcut icons on my Desktop, let's
say. Shortcut "A" would open up workbook "Master" to sheet "A." Shortcut
"B" would open up workbook "Master" to sheet "B." Shortcut "C" would open up
workbook "Master" to sheet "C." Shortcut "D" would open up workbook "Master"
to sheet "D."

 

[Gord Dibben]

You can open a workbook from a shortcut but you cannot designate which
worksheet it will open as active.

To specify the worksheet you must use VBA workbook_open code within the
workbook.

Or code to make that sheet active when you close and save.


Gord Dibben MS Excel MVP