Loading Specific Sub-Menu without HotKey

BTW. You can make the same things with VB only:

Code:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Target.Range.Row = 1 Then SendKeys("+^%K")
End Sub

I would LOVE to do it with SendKeys only but have never been able to get SendKeys working on my computer. SendKeys was the very first thing that i tried but was unsuccessful.

I have no idea why SendKeys does not work on my Win 7x64 computer. Any ideas would be MUCH appreciated.

Cheers;
Doc