View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Staying Productive Staying Productive is offline
external usenet poster
 
Posts: 1
Default 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