Desktop Shortcut points to Tab?

[mrpeace]

I am trying to figure out if there is a way to have a Desktop shortcut point to an Excel file and to a specific Tab within that file?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[venkat1926]

I shall think on these lines

put a short cut of the file on the desktop
now in the file create an event code that when that file opnes a particular sheet should be the active sheet (put this event code as thisworkbook code.


the sample code will be

Private Sub Workbook_Open()
Worksheets("sheet3").Activate
End Sub

so when you click the short cut the file open when the file opens sheet3 becomes active sheet.

 

[mrpeace]

Sir/Ma'am,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Thank you for your assistance, however this sounds like it will only work on one Tab within the document. I am not sure this will work for what I need! I will explain further, I have five different Categories all in one Excel (book) I need 5 desktop shortcuts that goes directly to each category Tab this way I have it set up so as when you click on "A" desktop shortcut it goes directly to the "A" tab inside the document and when you click on "B" it goes directly to the "B" tab inside the document etc....this way I have one to consolidated workbook for all my information however when I need to obtain information quickly and/or someone is accessing the separate files within the document they will be taken directly to the Tab with the information they need. I believe it will have to be some kind of Macro unless there is some code you can place in each Desktop shortcut? Thank you for assisting me in this question have a wonderful day! <o></o>

 

[mrpeace]

Thank You