Loading Specific Sub-Menu without HotKey

Hi Yuri;

I came to the same conclusion as you mentioned so i gave up trying to call TLB directly.

I found a work-a-round way to do it by creating a separate Modules TLB menu screen (SEE: JPEG) & assigning a HotKey to it. I than made a AutoHotKey exe file that contains the TLB HotKey. When I want to exit the Excel file & return to Modules TLB menu, I call the AHK exe file with a VBA script assigned to the title line (usually row one) simply by clicking anywhere on the title line (Inventory). It works very well.

The VBA script is a simply one liner...

Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Row = 1 Then Shell ("D:\Configs and Settings\AutoHotKey\Scripts\Load TLB Modules Menu.exe")
End Sub

The AHK script is also a simple one liner...

Send ^!+K

Where
^ = Ctrl
! = Alt
+ = Shift
K = the final key of the HotKey to send.

So I can now load all my important documents with TLB & return to TLB simply by clicking on the title line of the document.

Cheers;
Doc