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