View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Luc[_7_] Luc[_7_] is offline
external usenet poster
 
Posts: 21
Default How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?

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


"Chip Pearson" schreef in bericht
...
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]



On Fri, 18 Dec 2009 21:55:19 +0100, "Luc" wrote:

The title says it all....