Hyperlink To Open Workbook and Particular Tab (Sheet)..Possible?

Hello,

Is it Possible to use a hyperlink command to open a workbook and
a particular tab (sheet) within that workbook, or does it have to be in vba
coding?

If either is true, could you provide the coding for me... Thanks For Help On this..

Hi Stuie, and thanks for the reply.

Yes, In this case it will be one particular workbook "SuperLocator", that will
be used. But it will have Multiple Tabs within it that I will want to access.

I'll try your code and see if I can get it to work.

I'm assuming that it definately have to be a Macro in order to do this and
not a generic hyperlink command?

Thanks for the response...

I see,,

Stuie, give me a full example of your code above.. I'm amature also on this
and just can't seem to get your code to function correctly.. I think I'm
missing that Sub something and end sub. It doesnt show up on the Macro.

Thanks for your help..

I see we crossed paths posting

this is what I have using your code, but it's not running...

Workbooks.Open Filename:= _
"c:\superlocator.xls"

Sheets ("electronics")

thanks..

the macro code would be,

Please Login or Register  to view this content.

and then you can make a button on your worksheet to call this code, eg,

Please Login or Register  to view this content.

Thanks Very Much Stuie, You were very Helpful..

I can build on it from here... I Appreciate Your Help..