| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
The title says it all....
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
Not really. You should ALWAYS post your code(s) for comments and suggestions. Why select?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Luc" wrote in message ... The title says it all.... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent "Private Sub Workbook_SheetSelectionChange" to exec
Hi,
I assume you have code in this event that conditionally you don't want to execute. Tell us what this condition is. Mike "Luc" wrote: The title says it all.... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop the "flashing" when I execute an Excel macro? | Excel Discussion (Misc queries) | |||
| Error Message: "Can't Execute Code in Break Mode" | Excel Programming | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "method 'execute' of object 'find' failed" | Excel Discussion (Misc queries) | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
![Luc[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
