t;
>>>Forgive me if this is totally off-base.
>>>>But I have never used the Activate event in a Class module.
>>>>
>>>>In the ThisWorkbook module, I would use:
>>>>
>>>>Private Sub Workbook_Activate()
>>>> startappmon
>>>>End Sub
>>>>
>>>>I use t
_____
> From: aju chacko
> To: excel-macros@googlegroups.com
> Sent: Mon, September 26, 2011 1:10:44 PM
> Subject: Re: $$Excel-Macros$$ Trap window activate event from personal macro
> workbook
>
> Dear sam/paul
> Isempty(activece
From: aju chacko
To: excel-macros@googlegroups.com
Sent: Mon, September 26, 2011 1:10:44 PM
Subject: Re: $$Excel-Macros$$ Trap window activate event from personal macro
workbook
Dear sam/paul
Isempty(activecell.value) is OK now.But the macro
doesn't
work as i expected,I
-
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>>
To:* excel-macros@googlegroups.com
> *Sent:* Mon, September 26, 2011 5:53:07 AM
> *Subject:* Re: $$Excel-Macros$$ Trap window activate event from personal
> macro workbook
>
> dear sam,
> Thanks for your kindness.I have imported all the
> module as u mentioned,
-
From: aju chacko
To: excel-macros@googlegroups.com
Sent: Mon, September 26, 2011 5:53:07 AM
Subject: Re: $$Excel-Macros$$ Trap window activate event from personal macro
workbook
dear sam,
Thanks for your
dear sam,
Thanks for your kindness.I have imported all the
module as u mentioned,But the following line in class module is
throwing an error(syntax error)
' If Not IsEmpty(ActiveCell) Then'
But i didn't see anything wrong with this line.By the way i am using
excel 2007 and my
Where is the code.??
On Mon, Sep 26, 2011 at 10:07 AM, aju chacko wrote:
> Dear friends,
> I have created the following code to to trap
> "windowactivate" event and execute the code from personal macro
> workbook when the activate sheet name is "sap vs phy".But it works
