ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Highlighting with hyperlinks (https://www.excelbanter.com/excel-worksheet-functions/144955-highlighting-hyperlinks.html)

Klee

Highlighting with hyperlinks
 
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,



Gord Dibben

Highlighting with hyperlinks
 
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 InsertHyperlinkPlace in this
document.

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


Gord Dibben MS Excel MVP

On Sat, 2 Jun 2007 19:41:00 -0700, Klee wrote:

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,




All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com