Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change syperlink from single click to double click syperlinker Excel Worksheet Functions 0 June 13th 08 05:01 PM
double click insert date Slobodan Excel Worksheet Functions 1 February 16th 06 01:28 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
Q. How do I code a column to insert current date, when I double-click? George[_27_] Excel Programming 4 June 7th 05 04:11 PM
Mouse Over Graph, Capture Information on Click(Double Click) Dean Hinson[_3_] Excel Programming 1 December 6th 04 04:49 AM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"