How to prevent double-click, insert a row from workbook_sheetchange
 

I am using the workbook_sheetchange() to moniter the change in a range.
When a change is made, a message will be pop up. But I found when I
double-click to select a cell or insert a row cross the range, it will
also prompt message. Is there any way to prevent these ?

Does anyone know how to track what is before change and what is
after(not using track-change history?

Any help is appreciated!

Jeer


--
jeer
------------------------------------------------------------------------
jeer's Profile: http://www.excelforum.com/member.php...o&userid=30378
View this thread: http://www.excelforum.com/showthread...hreadid=520736