L
Luc
The title says it all....
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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]
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
(e-mail address removed)
The title says it all....
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
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
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
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....