excel selectionchange clashing with data update

I have an update routine that runs a number of subs that update various cells, however, the update is triggering:
Public Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

I dont want that to run while i am updating, I only wanted to use it after the cells were populated.

how do i achieve this?
PeterBaileyUkAsked:
Who is Participating?
 
Rory ArchibaldCommented:
Add:
application.enableevents = false

Open in new window

before the code that updates the cells then reset it to true afterwards. You could also simply not select any cells.
0
 
PeterBaileyUkAuthor Commented:
so simple but effective thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.