View Single Post
  #5   Report Post  
mike wilson
 
Posts: n/a
Default

thanks for the information.
It may be that I can lose the rightclick functionality in this case. I will
try it out and see.

"Vasant Nanavati" wrote:

There is no click event for a worksheet. You could use the SelectionChange
event but that would also fire when the cell is navigated to using the
keyboard.

You can trap the double-click or right-click event to accomplish this, but
then you would lose the normal double-click or right-click functionality.

--

Vasant


"mike.wilson" wrote in message
...
I want to use excel as a check list.
I would like to be able to have a cell turn a given colour when the cell

is
selected with the left mouse key.