Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Want to click on 1 cell and have it hyperlinked to a highlighted c
I am currently working on a spreadsheet.... What I want to do sounds so
simple but is very difficult to figure out. I want to be able to click on A1 cell and have it hyperlinked to another cell B2, but at the same time have B2 highlighted. Or I guess you can say is how can I click on A1 and have a section of this highlighted yellow, once I click out of A1 the highligh dissapeares? Any suggestions? |
#2
|
|||
|
|||
You would have to write a VBA macro, trapping the Selection_Change event to do
this. On Sun, 30 Jan 2005 20:00:03 -0800, "GutterPunk" wrote: I am currently working on a spreadsheet.... What I want to do sounds so simple but is very difficult to figure out. I want to be able to click on A1 cell and have it hyperlinked to another cell B2, but at the same time have B2 highlighted. Or I guess you can say is how can I click on A1 and have a section of this highlighted yellow, once I click out of A1 the highligh dissapeares? Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|