Worksheet_Change - determine how it is triggered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.????
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RAND() Won't Trigger Worksheet_Change 5
Data form not triggering Worksheet_Change event 3
Fire Worksheet_change event from module 3
Can Checkboxes trigger the Worksheet_Change code? 3
Worksheet_Change event not triggered as expected 4
Worksheet_Change Triggers on "Delete" but not on Data Entry 3
Worksheet_Change 3
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2

Back
Top