Dear Noorin/Rajan verma/Asa rossof,
*Thanks for ur
response*.I actually created a class module to trap double click event in
PIVOT Table,Now the code is written in such a way that when the user againg
double clck on drilled down sheet created by clicking on pivot
table,Another procedure *XX *executes.Now as suggested by asa I have
rewritten module in such a way that with the first double click itself the
procudre *XX also *executed by placing the call to the procedure in
suitable postion.
Aju v
chacko
On Thu, Dec 15, 2011 at 11:35 AM, NOORAIN ANSARI
<[email protected]>wrote:
> Dear Aju,
>
> Please find attached Worksheet Event Example sheet,
>
> HTH,
> --
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Wed, Dec 14, 2011 at 11:54 AM, Aju Chacko <[email protected]> wrote:
>
>> Dear experts,
>> Kindly help me with vba code for the following
>> problem ,I have created a macro *that trap the event DOUBLE CLICKING* of
>> mouse,But i want to optimize in such a way that the *user need not
>> double click each time with the mouse*,Instead I want to create *double
>> click of mouse using VBA CODE*,so when this code *create double click
>> event* ,the code written for this event will get fired.
>>
>> Thanking
>> you in advance
>>
>> Aju V Chacko
>>
>>
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to [email protected]
>>
>
>
> ** <http://noorain-ansari.blogspot.com/>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to [email protected]
>
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to [email protected]
