Consulting

Results 1 to 5 of 5

Thread: Solved: Copy Internet Icon from Desktop to Worksheet

  1. #1

    Solved: Copy Internet Icon from Desktop to Worksheet

    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?

  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Why not just insert a hyperlink? (Insert>Hyperlink...)

    If you need code:
    	ThisWorkbook.FollowHyperlink "http://www.vbaexpress.com"

  3. #3
    Quote Originally Posted by 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?
    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?
    Dave
    "The game is afoot Watson"

  4. #4
    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.

  5. #5
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •