Hyperlink tooltips

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

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

Brooke

Reply | Quote

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

Have a look at this thread in the Word forum.

Reply | Quote

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

Reply | Quote

Try this

Reply | Quote

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

Reply | Quote

I’m confused – I swear I changed it.
Try this one.

Reply | Quote

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:

c:Docs 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?

c:Docs 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

Reply | Quote

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)

Reply | Quote

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….

Reply | Quote

Transparency thing?
Clearly, it’s too early in the morning to follow . Are you referring to the flag?

Reply | Quote

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

Reply | Quote

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?

Reply | Quote