Hyperlink in Menu

[mbentley]

I want to be able to place a hyperlink in a custom menu and change the path at runtime using VBA. How do I do this?

 

[mbentley]

Answering my own question...again

Finally figured this out for anyone who cares:

CommandBars("[Menu Bar Name]").Controls("[Menu Name]").Controls("Menu Item Name").TooltipText = CurrentProject.Path & "\[File Name]"