+ Reply to Thread
Results 1 to 3 of 3

Cannot assign a hyperlink to a button

  1. #1
    Registered User
    Join Date
    11-01-2006
    Location
    Nottingham, UK
    Posts
    8

    Unhappy Cannot assign a hyperlink to a button

    I am tearing my hair out!

    I have spent the last couple of hours attempting to assign a hyperlink to a form button. The problem essentially is that when I right-click on the button to get the shortcut menu, it only has an option to assign a macro ... NOT a hyperlink.

    I am sure I have accomplished this before ... but why can't I do it now?

    Any offers?

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    09-28-2006
    Posts
    122
    I have never found a way to do this, but as a workaround i do the following

    put the hyperlink in a cell

    then write a macro something like

    'change this cell to match where you put your hyperlink
    Range("I10").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

    then assign this macr to the button (i also put the button over the top of the hyperlink cell so the user cant see it)

    hope this helps

  3. #3
    Registered User
    Join Date
    11-01-2006
    Location
    Nottingham, UK
    Posts
    8

    Smile

    Thanks PeeJay,

    ... it certainly works.

    However, one would hope at some stage that Microsoft would make this easier and more intuitive. We need an entry of 'Assign Hyperlink' from the shortcut menu ... surely it's not rocket science

    Andre

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1