View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Detecting Row Selection

Hi All
Is there a 'simple' way of detecting if a user selects an entire row in a
worksheet that can be used to trigger an event?

I have a need to control users who wish to delete an entire row by way of
the CTRL- sequence.

On another related matter, if a worksheet is protected (all cells) and an
autofilter is in place, is there a way to detect that the user is clicking
the autofilter ?

TIA
--
Cheers
Nigel