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
Dear friends,
I have created the following code to to trap
"windowactivate" event and execute a code from personal macro
workbook when the activate sheet name is "sap vs phy".But it works
only when the excel is opened for first time.Kindly check the code &
give necessary correc
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
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
only when the excel is opened for first time.Kindly check the code &
give necessary cor
10 matches
Mail list logo