Active-X Buttons

[mutrus]

How (where) can I find those Active-X buttons that act like a Hyperlink?

 

[white6174]

try this

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

End Sub

hope this helps

steve w

 

[mutrus]

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.

 

[white6174]

how about setting the mouse pointer icon

steve w

 

[mutrus]

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]

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]

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