How to Capture Edit Cell Event?
 

Hi Friends,

When we edit the cell the Excel toolbar's button become disable.
Please tell me how to disable button of my toolbar created using Macro
on cell edit? Is there any event to program this?


Regards,
Vinit

How to Capture Edit Cell Event?
 

Vinit,

I would advise against this. While it is possible to do this with VBA,
this VBA action will clear your Excel Undo list as well. Not the best
tradeof you could have.

DM Unseen

How to Capture Edit Cell Event?
 

Hi DM,
Thanks.
Can u tell me how it is possible using MACRO? bcoz while editing the
cell if user click toolbar button it doesnt perform the required
action, it gives bad impression to user. So I want to disable my
buttons while editing the cell like Excel do for itself.

Regards,
Vinit

How to Capture Edit Cell Event?
 

Vinit

VBA=MACRO!

DM Unseen