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

    Hyperlink tooltips

    I'm using hyperlinks to navigate between sheets in a workbook, with each item on sheet "contents" hyperlinked to cell a1 on the relevant sheet and cell a1 on each sheet hyperlinked back to the contents sheet. This works fine but I get a tooltip for each hyperlink showing the path of the workbook, which I don't want.

    I can't see how to turn them off (or edit what they say). Is this possible without VBA? Is it possible with VBA?

    Or is there a better way of doing this?

    Thanks

    Brooke

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips

    In Excel 2K :
    Right_Mouse | Hyperlink | Edit Hyperlink
    To the right of the 'Text to display field' is a button labeled 'Screen Tip' - this changes what is displayed.

    As far as VB goes, this is from the help file and may be adaptable:

    With Worksheets(1)
    .Hyperlinks.Add Anchor:=.Range("a5"), _
    Address:="http://example.microsoft.com", _
    ScreenTip:="Microsoft Web Site", _
    TextToDisplay:="Microsoft"
    End With

  3. #3
    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 tooltips

    Unfortunately, it doesn't appear to be there in 97!

    I'll have a play with the code and see whether that works.

    Brooke

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips

    Ah - you could be right about it not being an option.

    Have a look at this thread in the <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=13195&page=&view =&sb=&vc=1>Word</A> forum.

  5. #5
    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 tooltips

    Leif (or anyone else - I'm not picky!)

    I've not had any joy so far. Is there any chance you could alter with 2k the tip on the attached worksheet and repost it so that I can see whether 97 will recognise changes once they've been made?

    TIA

    Brooke
    Attached Files Attached Files

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips

    Try this
    Attached Files Attached Files

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

    I take it you didn't change it to:

    http://www.wopr.com/w3tfiles/5-27040-brooke.xls

    At least that saves me the problem of persuading IS that I really do need to run multiple versions of excel on my machine.

    Thanks again

    Brooke

  8. #8
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips - take 2

    I'm confused - I swear I changed it.
    Try this one.
    Attached Files Attached Files

  9. #9
    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 tooltips - take 2

    You may well have done - but whatever I do it shows the current path - so when i save to C: the first one you reposted it shows:

    cocs and SetsBrookeMy Docswopr5-27040-brooke.xls

    as opposed to :

    http://www.wopr.com/w3tfiles/5-27040-brooke.xls

    when i open it straight from the forum. And the one you've just posted?

    cocs and SetsBrookeMy Docswopr5-27049-xx.xls

    To me that looks like a version thing - what looks like a tip in 97 is in fact just an "unalterable path info tip" as opposed to a "user definable tip" in 2k. If I could just turn it off, that would be something......

    Brooke

  10. #10
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips - take 2

    I think I mixed up the first attempt with what I'd downloaded and what I saved after altering.
    With the second version, opening up in the IExplorer window, I get this (the mouse-hand hasn't been captured)
    Attached Images Attached Images
    • File Type: gif x.gif (12.0 KB, 0 views)

  11. #11
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips - take 2

    Hang on - I may have stumbled onto something (in Excel 2K anyway) .
    If you add a comment to a cell, this over-rides the screen tip.
    Will it work for you?

  12. #12
    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 tooltips - take 2

    Thanks for your help, but I think this one is dead in the water. There's a very definite difference between the two versions. I think what I'll end up doing here is using command buttons with a caption of "GO TO SHEET" beside each entry on the contents sheet and code "sheet("x").activate" (or similar) behind each button. Now I just have to decide whether forms/button or control toolbox/command button is better...

    I was playing with this earlier (command button) and i seem to have run into the problem that i can set a command button to transparent but when i click the button and go to another sheet, and then return to the contents page, the command button resets to opaque. Seems a little odd to me...

    interupted by...

    Hang on - I may have stumbled onto something (in Excel 2K anyway) .
    If you add a comment to a cell, this over-rides the screen tip.
    Will it work for you?

    Leif

    .....

    Yes, it seems to! Of course, I may run into the problem that the powers that be don't like the slightly different format....

    (incidentally, tools/options/view/comments/none = checked still gives the path tooltip)

    Now I just have to try it on the live spreadsheet and make sure it works when posted to a notus lotes database, and ask the boss if she likes the look of it, but thank you - I can stop working now and go to bed a happy bunny! I'll post tomorrow on whether this works live.

    Brooke

    p.s. - about that transparency thing....

  13. #13
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink tooltips - take 2

    Transparency thing?
    Clearly, it's too early in the morning to follow <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> . Are you referring to the flag?

  14. #14
    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 tooltips - take 2

    No - the command button thing - in an attempt to mimic a hyperlink I was formatting the cell text like a hyperlink and trying to place a transparent command button over the top of it with code in the click event to go to the desired sheet - but when I come back to the contents page the command button is opaque again. I guess I can get round this by placeing code in the worksheet activate event but it just seemed a little odd.

    Brooke

Posting Permissions

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