Highlighting with hyperlinks

K

Klee

Hello,
Does anyone know if there a way to have the cell that a hyperlink goes to
become highlighted when the hyperlink is used within the same workbook?

Also can you use a hyperlink to go to (and hopefully hightlight) a series of
cells rather than just one?

Thanks very much,
 
G

Gord Dibben

Highlighted as in colored?

Probably need some event code but too late in day for me.

To select a range of cells right-click and Insert>Hyperlink>Place in this
document.

Select a sheet and in the cell reference type A1:A10.


Gord Dibben MS Excel MVP
 
Top