View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default VB CODE for double click?

if target.column<1 then exit sub
target.entirerow.insert

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CAPTGNVR" wrote in message
...
DEAR ALL

Can someone suggest me a VB code to be placed in sheet event
BeforeDoubleClick so that any cell I double click in colum A, it calls for
macro 'insert_tow'.

If i get this code, I am done for the day as the program is complete with
this.

Pls help.

brgds/captgnvr