View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default Explorer shortcut to specific Worksheet (tab)

I don't think that is possible...

See http://scriptorium.serve-it.nl/view.php?sid=65 for a creative solution.

It is easier to have a macro which will prompt you with a list of tabs and
allows you to pick the one you want...

"Dan Kelly" wrote:

Is there anyway that I can create a shortcut in Windows Explorer to an Excel
Workbook and have it open a specific tab rather than the first one?

The standard "Create Shortcut" interface doesn't like the square brackets in
that are generated within Excel