Thread: How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
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....
Reply With QuoteReply With Quote