+ Reply to Thread
Results 1 to 3 of 3

How to add Hyperlink on Command Button and Back Button

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    Malaysia
    Posts
    12

    How to add Hyperlink on Command Button and Back Button

    Greetings. I'm currently preparing a post mortem report for a completed project. There are several lessons learned throughout the duration of the project and I'm displaying them via chronological event base on a given timeline. This timeline consists of labelled crucial events that are clickable (hyperlink on command buttons). Each click will send the viewer to a new woksheet that describes the crucial event in detail and there is a back button that will immediately send the viewer back to the timeline once they've read the details. I have 8 crucial events on the timeline and would appreciated if someone is able to help me on this. A detail step by step advice is appreciated as I'm still a novice excel user. Thanks in advance.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to add Hyperlink on Command Button and Back Button

    if you really want buttons one way is to use a forms button and add a macro to it
    insert something like this in a new module(right click tab, select view code, then in the window that opens click insert module, an paste code below in)
    so 11 sheets would need 20 of these 1 to jump to each sheet and 1 to jump back to where you came from in sheet 1
    this shows just 5 examples

    Please Login or Register  to view this content.
    Then use a forms button on each sheet right click it assign macr0 and pick the one you need from the window that appears.
    Last edited by martindwilson; 02-08-2009 at 01:32 PM.

  3. #3
    Registered User
    Join Date
    12-17-2008
    Location
    Malaysia
    Posts
    12

    Re: How to add Hyperlink on Command Button and Back Button

    Thank you so much. It's very helpful.

+ 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