How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
in [Programming]
|
Prev: How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
Next: Creating folder names from column data in excel
From: Chip Pearson on 18 Dec 2009 16:11 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" <lferr(a)base.be> wrote: >The title says it all....
From: Don Guillett on 18 Dec 2009 16:12 Not really. You should ALWAYS post your code(s) for comments and suggestions. Why select? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1(a)austin.rr.com "Luc" <lferr(a)base.be> wrote in message news:%23j0WRSCgKHA.2164(a)TK2MSFTNGP02.phx.gbl... The title says it all....
From: Luc on 19 Dec 2009 07:37
Thanks for your help, that did the job !! Luc "Chip Pearson" <chip(a)cpearson.com> schreef in bericht news:ltrni518ofjpnjm87kog5mrfqrtnmhmu62(a)4ax.com... > 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" <lferr(a)base.be> wrote: > >>The title says it all.... |