Desktop Shortcut points to Tab?

mrpeace

New Member
Joined
Apr 16, 2010
Messages
3
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-com:eek:ffice:eek:ffice" /><o:p></o:p>
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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

Code:
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

New Member
Joined
Apr 16, 2010
Messages
3
Sir/Ma'am,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
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:p></o:p>
 

Watch MrExcel Video

Forum statistics

Threads
1,102,304
Messages
5,486,065
Members
407,530
Latest member
Shameem Khan

This Week's Hot Topics

Top