Solved: Copy Internet Icon from Desktop to Worksheet

[Cyberdude]

I have an icon on my desktop that brings up this forum. I click it and ...voila!...here I am! How can I copy that icon from my desktop to an Exccel worksheet. I tried dragging it, but it created a new workbook...not at all what I wanted. Perhaps a better question is, how do I create a button on my worksheet that when clicked will take me to a web site?

[Norie]

Why not just insert a hyperlink? (Insert>Hyperlink...)

If you need code:


ThisWorkbook.FollowHyperlink "http://www.vbaexpress.com"

[Desert Piranha]

I have an icon on my desktop that brings up this forum. I click it and ...voila!...here I am! How can I copy that icon from my desktop to an Exccel worksheet. I tried dragging it, but it created a new workbook...not at all what I wanted. Perhaps a better question is, how do I create a button on my worksheet that when clicked will take me to a web site?Hi,
Can you "insert object", Browse, find the icon you want and click ok. Format the object (icon) "no line & no color", that way just the actual icon shows. Then assign a macro to it,to connect to the site?

[Cyberdude]

Thanks for the great replies, Guys! Hyperlink...of course! Duh. Don't know why I didn't think of that, but some days are like that.

[mdmackillop]

:old: