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
Issue With Macro Sheduling Using On Time Event 0
Cumulative formula for word table 0
Need to Capture the initial value of a cell. 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Disabling "group edit" mode in Excel 4
macro to run in event of cell value <>"" 2
How to Capture right click Delete/Insert on Excel 8

Top