Programming hyperlink into pulldown menu

I wonder if anyone can help?

Currently, I have code to program a pull-down menu ('File') to display 2 options ('About GROW' and 'Print') to run respective subs 'CallDocMenu' and 'ZPrintAll'. Both of these subs calls up a worksheet. However, I now need one of the options to be an external hyperlink.

The code to program the 'File' pulldown is:

MenuBars(xlWorksheet).Menus.Add "&File"
    MenuBars(xlWorksheet).Menus("File").MenuItems.Add "&About GROW", "CallDocMenu"
    MenuBars(xlWorksheet).Menus("File").MenuItems.Add "-"
    MenuBars(xlWorksheet).Menus("File").MenuItems.Add "&Print", "ZPrintAll"

and sub 'CallDocMenu' has the following code:

Sub CallDocMenu()
    Worksheets("DocMenu").Select
End Sub

So, instead of option 'About GROW' calling up sheet 'DocMenu', it needs to follow an external hyperlink eg http://www.gest.com/growdoc.pdf

Can anyone help with this?

Thanks in anticipation

..... Andre

Maybe you can make use of the FollowHyperlink method

Direct from help file.

ActiveWorkbook.FollowHyperlink Address:="http://example.microsoft.com", _
    NewWindow:=True

Originally Posted by Andy Pope

Maybe you can make use of the FollowHyperlink method

Direct from help file.

ActiveWorkbook.FollowHyperlink Address:="http://example.microsoft.com", _
    NewWindow:=True

This worked!

I replaced my

 'Worksheets("DocMenu").Select'

with your code.

Thank you very much Andy

..... Andre