How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed

  • Thread starter Thread starter Luc
  • Start date Start date
You can turn off event handling with the Enable Events property:

Application.EnableEvents = False
' your code here
Application.EnableEvents = True

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Not really. You should ALWAYS post your code(s) for comments and suggestions. Why select?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
The title says it all....
 
Hi,

I assume you have code in this event that conditionally you don't want to
execute. Tell us what this condition is.

Mike
 
Thanks for your help, that did the job !!
Luc


Chip Pearson said:
You can turn off event handling with the Enable Events property:

Application.EnableEvents = False
' your code here
Application.EnableEvents = True

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



The title says it all....
Click to expand...
Click to expand...
 

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

Problem with Set stmt in Workbook_SheetSelectionChange event 6
Workbook_SheetSelectionChange problem in my add in 3
Trapping events within a Workbook_SheetSelectionChange event 1
unresolved post: Add in and the worksheetselectionchange interacti 1
Outlook Private Sub Application_Startup()....What if it be public 1
After module import, code does not work 3
Workbook_SheetSelectionChange in an Addin 3
How it must fix ? 0

Back
Top