View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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,