How to create a hyperlinked menuitem

I'm creating a menu with menuitems.

Is there an easy way to add a hyperlink to a menu instead of a macro?


With mybutton.customMenu.controls.add(type:=msocontrolbutton)
.caption = "Userdocumentation"
.faceid = 277
.onaction = "macro1"
end with

I want to replace the ".onaction" with a hyperlink to a user document insted.

Thanks.

Not sure, but you could always just get macro1 to open the document.

TJ

Not sure, but you could always just get macro1 to open the document.

TJ

Exactly. You may need to use the OnAction API function to ensure that Windows opens the file with the proper program.

Exactly. You may need to use the OnAction API function to ensure that Windows opens the file with the proper program.

Perhaps you could use the workbook object's followhyperlink method?

Perhaps you could use the workbook object's followhyperlink method?

Wow. Sure enough. I'd never heard of that method before. Is it new?

Gosh, now you're asking Mill! :)

I believe it was around in Excel 97 [but don't take my word for it].

Gosh, now you're asking Mill! :)

I believe it was around in Excel 97 [but don't take my word for it].

That could have saved me a minor bit of typing at one point. I got comfortable with the ShellExecute API back when I was using VB 3.1 or something like that.

Ooh, and the FollowHyperLink method is available in Access as well. Nice.

And it also works with e-mail addresses. It may not have all of the flexibility of the ShellExecute function (I'm not sure yet, though), but I'd prefer to use inherent functions instead of API if I can.

Just did a quick google and it was around in Excel 97 although it was a bit buggy when using "Mailto:" / method:=msoMethodPost.

http://support.microsoft.com/kb/161324

Anyway. This means that I have to crate a Sub for each menuitem

Anyway. This means that I have to crate a Sub for each menuitem

Correct metropol, and you are welcome.

For some reason, I thought you could use Application.Caller from a sub called by a menu click. However, I couldn't make it work it my mini-test, and didn't find anything to support my pseudo-memory of such.

For some reason, I thought you could use Application.Caller from a sub called by a menu click. However, I couldn't make it work it my mini-test, and didn't find anything to support my pseudo-memory of such.

Of course you could use a 'communal' subroutine for the "menuitems" rather than individual routines - my confirmation was meant more towards the notion that you can't anchor a hyperlink to a "menuitem" :)

Thank you for helping me out with this one. I have no a working routine, using followhyperlink.

Best Regards

Thank you for helping me out with this one. I have now a working routine, using followhyperlink.

Best Regards

Great work Metropol! :cool: .... I'm glad we were able to help you! :)