Append shortcut link to open a particular workbook TAB

[bob]

Workbook named Finance with tabs such as Sheet1, Sheet2, Sheet3 etc.
except I have them named differently than what the default is.

A typical Link window appears as :C:\Financial\Finance-2011b.xls
I want to add address code to open a particular Sheet TAB. Is this
possible and does anyone know how to do it?

Thanks friends for any help you can give me.
Bob

 

[Jim Cone]

A couple of alternatives...
1. The sheet that is active (displayed), when you save a workbook,
is the one displayed when the workbook is opened.
2. You could add VBA code to the ThisWorkbook module to force
a switch to particular sheet when the workbook opens.
The user would have to enable macros....
'---
Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sludge").Activate
End Sub
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"bob" <[email protected]>
wrote in message
news:4dd2a49b-5d6f-41d3-9406-a6b7bd4d9ee3@r21g2000yqd.googlegroups.com...