Opening a webpage from a toolbar button

[NZ VBA Developer]

I imagine this is probably a one-liner: Is there a way to open a webpage by
clicking on a toolbar button? I suspect it's something to do with 'shell' but
my brain is mush and I don't even know where to start...

 

[Tony Jollans]

Create your toolbar button something like this:

Set HyperButton = CommandBars("Menu Bar").Controls.Add(ID:=1576)
HyperButton.HyperlinkType = msoCommandBarButtonHyperlinkOpen
HyperButton.TooltipText = "http://whatever/your/url/is"

 

[NZ VBA Developer]

Thanks Tony. I'll have a bang this arvo - after my brain has re-solidified.

 

[avkokin]

Create your toolbar button something like this:

Set HyperButton = CommandBars("Menu Bar").Controls.Add(ID:=1576)
HyperButton.HyperlinkType = msoCommandBarButtonHyperlinkOpen
HyperButton.TooltipText = "http://whatever/your/url/is"

Hello Tony!
Please help me about for a piece of code - ".Add(ID:=1576)". What mean
is 1576?
Thank you!

 

[Tony Jollans]

1536 id the ID of the hyperlink toolbar button. It just means that's the
type of button you want.