Hi,
I've got a spreadsheet where I'm using it to visually display data on a "plot plan".
I have various shapes on the plan and set up Message boxes so that they display what they are.
This is where I've go stuck, I also want the corresponding row to be highlighted ( the Row contains more data)
So basically what I want is:
- When the shape is clicked the corresponding row to be highlighted
- When the same shape is clicked again the row is "un"highlighted
Can this be done?
Any help would be appreciated.
Cheers
Cammy
I've got a spreadsheet where I'm using it to visually display data on a "plot plan".
I have various shapes on the plan and set up Message boxes so that they display what they are.
This is where I've go stuck, I also want the corresponding row to be highlighted ( the Row contains more data)
So basically what I want is:
- When the shape is clicked the corresponding row to be highlighted
- When the same shape is clicked again the row is "un"highlighted
Can this be done?
Any help would be appreciated.
Cheers
Cammy