Posted to microsoft.public.excel.programming

Devvy D

external usenet poster

Posts: 2

Workbook_SheetChange triggered to many times

Hi there!

When user enters some text in a cell, I use macros to validate.
If there are some incorrect data I want to correct this
programmatically. So I use the SheetChange event.

The problem is that when I correct what the user entered, the event
is fired once again, and then again and again and again... I think you
understand the problem...

How can I work around this problem, is it for example possible to
temporarily disable the event?

Best Regards

L-E

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Worksheet_Change and Workbook_SheetChange not firing	David Jenkins[_2_]	Excel Programming	4	September 2nd 04 08:02 PM
Workbook_sheetChange event	J S	Excel Programming	0	August 9th 04 07:16 PM
workbook_sheetchange	JulieD	Excel Programming	1	June 14th 04 04:32 AM
Problem with the Workbook_SheetChange event???	angel	Excel Programming	0	January 29th 04 02:56 PM
Workbook_SheetChange will not fire	Robert Willard	Excel Programming	1	September 10th 03 07:52 PM

All times are GMT +1. The time now is 11:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us