Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Workbook with Multiple Windows | Excel Discussion (Misc queries) | |||
Desktop Shortcut to Specific Sheet in Excel | Excel Discussion (Misc queries) | |||
How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
I need a shortcut to make a excel file open to a specific sheet | Excel Discussion (Misc queries) | |||
How do I open a specific worksheet using windows exp... | Excel Discussion (Misc queries) |