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

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" <(E-Mail Removed)>
wrote in message
news:4dd2a49b-5d6f-41d3-9406-(E-Mail Removed)...
> 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