Explorer shortcut to specific Worksheet (tab)
 

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

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