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
Bookmarks