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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
try this

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

End Sub

hope this helps

steve w
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,222,072
Messages
6,163,746
Members
451,855
Latest member
mcook36155

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
Back
Top