Active-X Buttons

mutrus

Board Regular
Joined
Sep 10, 2002
Messages
80
How (where) can I find those Active-X buttons that act like a Hyperlink?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

white6174

Board Regular
Joined
May 6, 2002
Messages
137
try this

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink Address:="http://mrexcel.com"

End Sub

hope this helps

steve w
 

mutrus

Board Regular
Joined
Sep 10, 2002
Messages
80
I'm sorry - I should have been more explicit. I have seen worksheets that have a button on them that when the mouse hovers over it turns into a hand.

I think its an active-x button, the property sheet is different to the standard button.
 

mutrus

Board Regular
Joined
Sep 10, 2002
Messages
80

ADVERTISEMENT

Apologies - I am unable to display the property sheet for this object (it just wont) so cannot set mouse pointer

I mean't (orig post) that the Format Control property is different from the standard button one
 

white6174

Board Regular
Joined
May 6, 2002
Messages
137
Are you using a command button from the control toolbox?

It sounds like your using one from th forms toolbar

hope this helps steve w
 

mutrus

Board Regular
Joined
Sep 10, 2002
Messages
80
Thats it, but in reverse.

The effect I wanted was to use the button from the forms toolbar on a sheet.

I was using the button from the sheets toolbar

Thanks
 

Forum statistics

Threads
1,144,446
Messages
5,724,400
Members
422,550
Latest member
Parvin_B

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top