Prev: Active sheet problem / macro button
Next: Using Cell.Replace
From: IanC on 15 Apr 2010 13:52
Is there any way to suppress Worksheet_SelectionChange in instances where
the selection change comes from a programmed command rather than user
action?

--
Ian
--


From: B Lynn B on 15 Apr 2010 17:13
Application.EnableEvents = False

Insert just before the line of code that would otherwise trigger the event.
Make sure you always get it set back to True before code stops executing,
whether by error handler or before end/exit sub.

"IanC" wrote:

> Is there any way to suppress Worksheet_SelectionChange in instances where
> the selection change comes from a programmed command rather than user
> action?
>
> --
> Ian
> --
>
>
> .
>
From: IanC on 16 Apr 2010 06:37
Many thanks to B Lynn B & Tim Williams.

Application.EnableEvents = False does exactly what I need.

--
IanC
--


"IanC" <me(a)me.com> wrote in message
news:RvKxn.66760$5x6.5515(a)newsfe04.ams2...
> Is there any way to suppress Worksheet_SelectionChange in instances where
> the selection change comes from a programmed command rather than user
> action?
>
> --
> Ian
> --
>
>


 | 
Pages: 1
Prev: Active sheet problem / macro button
Next: Using Cell.Replace