View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Can I highlight one cell when clicking on another cell?

Well, technically speaking you can do what you want by adding VBA code to the
sheet's Worksheet_SelectionChange event. However, if you're not allowed to
Freeze Panes, there's no way you'll be allowed to add macro code.

Can't you make a copy of the sheet and Freeze column A on the copy?

"Oldersox" wrote:

I have a spreadsheet which is rather large and has to be viewed at a rather
small size. I am restricted in that I cannot Hide, Split or Freeze anything
on the worksheet (blame internal politics at the company I work for for that
decision)
Is there a way that when I click on a cell (say K1) so that the data in
another cell (say A1) can be displayed with alternate formatting features (eg
bold or a different colour font/cell color) or that a pop-up window can
appear with the data from another cell. The 'other' cell I want to display
contains only a date and does not get updated for the life of the
spreadsheet. The cell to be displayed is always relative to the row in which
the cell I am selecting eg.
A1 K1
A2 K2
A3 K3