Disable SelectionChange Event

I have a spreadsheet which has code behind the SelectionChange event. When I
am working on (editing) the worksheet, I want the code active. Later, when I
run a macro to do processing on the worksheet, I want this code deactivated.

Is it possible to use EnableEvents and specify a specific workbook and/or
worksheet and/or event (the SelectionChange event), or does EnableEvents
always apply to the entire application? Is there anyway to disable a
specific event, or is that ever really necessary?

Does EnableEvents affect anything other than workbook and worksheet events?
It seemed to bypass an InputBox sequence when I set it equal to false in one
test.

--
Bill @ UAMS

Application.enableevents is an application property.

You could turn it off before you do anything in your macro--it'll affect both
workbook, worksheet and application events.

If you want to be more specific, you could set up a global variable:

Public BlkMyEvents as boolean

sub testme()
blkmyevents = true
'do something that would cause a specific event to fire
'select a cell on a worksheet with a _selectionchange procedure
blkmyevents = false
end sub

Then behind that worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if blkmyevents = true then exit sub
'normal code here.
End Sub



BillCPA wrote:
>
> I have a spreadsheet which has code behind the SelectionChange event. When I
> am working on (editing) the worksheet, I want the code active. Later, when I
> run a macro to do processing on the worksheet, I want this code deactivated.
>
> Is it possible to use EnableEvents and specify a specific workbook and/or
> worksheet and/or event (the SelectionChange event), or does EnableEvents
> always apply to the entire application? Is there anyway to disable a
> specific event, or is that ever really necessary?
>
> Does EnableEvents affect anything other than workbook and worksheet events?
> It seemed to bypass an InputBox sequence when I set it equal to false in one
> test.
>
> --
> Bill @ UAMS

--

Dave Peterson

I put in the stuff for using a specific variable. Works well - thanks for
your help!

--
Bill @ UAMS


"Dave Peterson" wrote:

> Application.enableevents is an application property.
>
> You could turn it off before you do anything in your macro--it'll affect both
> workbook, worksheet and application events.
>
> If you want to be more specific, you could set up a global variable:
>
> Public BlkMyEvents as boolean
>
> sub testme()
> blkmyevents = true
> 'do something that would cause a specific event to fire
> 'select a cell on a worksheet with a _selectionchange procedure
> blkmyevents = false
> end sub
>
> Then behind that worksheet:
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> if blkmyevents = true then exit sub
> 'normal code here.
> End Sub
>
>
>
> BillCPA wrote:
> >
> > I have a spreadsheet which has code behind the SelectionChange event. When I
> > am working on (editing) the worksheet, I want the code active. Later, when I
> > run a macro to do processing on the worksheet, I want this code deactivated.
> >
> > Is it possible to use EnableEvents and specify a specific workbook and/or
> > worksheet and/or event (the SelectionChange event), or does EnableEvents
> > always apply to the entire application? Is there anyway to disable a
> > specific event, or is that ever really necessary?
> >
> > Does EnableEvents affect anything other than workbook and worksheet events?
> > It seemed to bypass an InputBox sequence when I set it equal to false in one
> > test.
> >
> > --
> > Bill @ UAMS
>
> --
>
> Dave Peterson
>