| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change - determine how it is triggered
Hi, I'm using a Showcase Query Addin to refresh the data in my worksheet.
I'm also using a Worksheet_Change Event to do thing when the user changes the value in cells. the problem is that the worksheet Change event is getting triggered by the Showcase query refresh, but I don't want it to.. any ideas.???? -- Tks, J Sears |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet_Change - determine how it is triggered
Application.EnableEvents = False
before the query, then reset after. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "J Sears" wrote in message ... Hi, I'm using a Showcase Query Addin to refresh the data in my worksheet. I'm also using a Worksheet_Change Event to do thing when the user changes the value in cells. the problem is that the worksheet Change event is getting triggered by the Showcase query refresh, but I don't want it to.. any ideas.???? -- Tks, J Sears |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In the worksheet_change event, how do I determine what occured? | Excel Worksheet Functions | |||
| Worksheet_Change Event triggered off specific cell | Excel Programming | |||
| worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
| worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
Linear Mode
