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

C

Chip Pearson

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]
 
D

Don Guillett

Not really. You should ALWAYS post your code(s) for comments and suggestions. Why select?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]
The title says it all....
 
M

Mike H

Hi,

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

Mike
 
L

Luc

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...
 
Top