Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink on a User Form

    Hi all,

    I have a workbook which is currently used by about 50 people. The latest version is greatly improved, therefore vastly more complicated, and therefore, greatly subject to some oversight on my part. Total workbook size is around 2 megs.

    So....I would like to put a hyperlink on a user form similar to the hyperlink you might insert into an actual worksheet - such as "mailto: uthoughtuhaditright@whoknows.net". Ideally, I would like to attach this command or code (if need be) to a button in a user form, so that the Outlook Express mail screen will open and the user can email me with areas that might possibly contain an error.

    Is this possible, or do I need to put the hyperlink in the sheet itself? I am and the rest of the users are using Excel 2000 on a combination of Win98SE and WinME.

    Thanks,

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink on a User Form

    This is for 97 not 2000, but does <A target="_blank" HREF=http://j-walk.com/ss/excel/tips/tip71.htm>j-walk</A> have the answer for you?

    Brooke

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink on a User Form

    Thanks Brooke, that worked wonderfully!

    <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

Posting Permissions

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