How to Capture Edit Cell Event?

V

Vinit

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
 
D

DM Unseen

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
 
V

Vinit

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable CommandBar buttons while editing the cell 1
Disabling "group edit" mode in Excel 4
Can macro return me to cell edit mode 3
capture right mouse button click event on cell 1
How to Capture right click Delete/Insert on Excel 8
user editing cell when code runs 6
macro to run in event of cell value <>"" 3
VSTO BeforeDoubleClick edit mode 6

Top