Is there a way to load a single Excel worksheet TAB with a TLB shortcut?
EXAMPLE: I have an Excel workbook with 10 tabs (worksheets). I want to open tab number 3 only and not the last tab that the workbook was saved to.
I can do this through another Excel workbook either with Hyperlinks or VBA but I want to do it through TLB.
Is there an extension that I can add to the TLB shortcut to allow opening just the tab that I want?
Thanks;
Doc
Is this possible without TLB? I'm not sure
Hi Yuri;
I don't understand the answer...
"Is this possible without TLB? I'm not sure "
WITHOUT TLB?
That's' not what I'm asking. I want to load the worksheet tab THROUGH (or WITH) a TLB shortcut.
Thanks;
Doc
I'm sorry, I don't know how to load the single worksheet tab. I'm not sure this is possible, Excel loads the file not a part of file.
(08-18-2012, 08:33 AM)Yuri Kobets Wrote: [ -> ]I'm sorry, I don't know how to load the single worksheet tab. I'm not sure this is possible, Excel loads the file not a part of file.
True, but Excel allows you to load the file with a specified tab open; this can be done within Excel two ways that I know of...
1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
2: Through... VBA file open command with the file tab as an extension.
What I am thinking is if it can be done through VBA (with a switch for the tab) it should be possible to do it with the proper switch within a TLB shortcut. I just can't find the correct switch to do the job through TLB shortcuts.
Thanks;
Doc
Quote:1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
Is this possible to craete shortcut on the desktop? If yes, just copy this shortcut to TLB.
Quote:2: Through... VBA file open command with the file tab as an extension.
OK, you can create VBA file and place shortcut on TLB.
(08-18-2012, 09:56 AM)Yuri Kobets Wrote: [ -> ]Quote:1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
Is this possible to craete shortcut on the desktop? If yes, just copy this shortcut to TLB.
No, Hyperlinks are strictly between MS Office applications.
Quote:2: Through... VBA file open command with the file tab as an extension.
OK, you can create VBA file and place shortcut on TLB.
I have been thinking the same thing; will give it a try.
Thanks;
Doc