Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Windows Shortcut to Open to Specific Sheet in Workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Windows Shortcut to Open to Specific Sheet in Workbook
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Windows Shortcut to Open to Specific Sheet in Workbook
" 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Windows Shortcut to Open to Specific Sheet in Workbook
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." "trip_to_tokyo" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Windows Shortcut to Open to Specific Sheet in Workbook
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 On Tue, 22 Dec 2009 07:37:02 -0800, Staying Productive wrote: 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." "trip_to_tokyo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |