ll need a more detailed description for how you WANT it to work.
> >
> > Paul
> >
> >
> >
> >
> >
> >
> >
> > - Original Message
> > > From: Ted
> > > To: MS EXCEL AND VBA MACROS
> > > Sent: Mon, Novemb
> To: MS EXCEL AND VBA MACROS
> > Sent: Mon, November 1, 2010 12:09:33 PM
> > Subject: Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module
>
> > Thank you. I added EnableEvents = true and used the function I vound
> > "App_SheetChange" to acc
ailed description for how you WANT it to work.
Paul
- Original Message
> From: Ted
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, November 1, 2010 12:09:33 PM
> Subject: Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module
>
> Thank you. I added EnableEven
Thank you. I added EnableEvents = true and used the function I vound
"App_SheetChange" to access the sheet when things changed. Is that
right? It didn't seem to do what I wanted it to.
On Nov 1, 9:32 am, Paul Schreiner wrote:
> Application.EnableEvents = true/false
> allows you to turn on/off
Application.EnableEvents = true/false
allows you to turn on/off ALL events, not just sheet change events,
but also BeforeSave, close, activate/deactivate, etc...
If you only want to turn on/off a specific event handler,
you can declare a Public variable like;
Public ChangeFlag
Set it to true/fal
