Results 1 to 2 of 2

Thread: creating hyperlink in excel vba

Threaded View

  1. Mar 7th, 2006, 07:00 AM #1
    sweet_dreams
    sweet_dreams is offline

    Thread Starter
    Addicted Member sweet_dreams's Avatar
    Join Date
    Apr 2005
    Location
    Poland, Lodz
    Posts
    189

    Question creating hyperlink in excel vba

    Hi all,

    I was trying to create hyperlink to other sheet in excel I did it like
    that:

    VB Code:
    1. Sheets(2).Activate 

    2. Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List"

    but it doesn't work.

    Can U tell me what's wrong???

    regards,
    sweet_dreams
    Last edited by sweet_dreams; Mar 7th, 2006 at 07:04 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width