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
> then, within your event, check this status before running.
> If (not ChangeFlag) Then Exit Sub
>
> hope this helps,
>
> Paul
>
>
>
>
>
>
>
> - Original Message
> > From: Ted
> > To: MS EXCEL AND VBA MACROS
> > Sent: Mon, Novemb
/false
then, within your event, check this status before running.
If (not ChangeFlag) Then Exit Sub
hope this helps,
Paul
- Original Message
> From: Ted
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, November 1, 2010 8:20:52 AM
> Subject: $$Excel-Macros$$ $$Excel Macros$$ Work
I use one book for portability of macros and I'd like to be able to
turn on and off a worksheet_change macro from the book, not by adding
the script to each individual worksheet. I can't find any information
on this anywhere, so I thought this would be a good place to ask. All
I can think of is w
