| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Capture Edit Cell Event?
Vinit
VBA=MACRO! DM Unseen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture the hyperlink event before it goes to the link | Excel Discussion (Misc queries) | |||
| capture right mouse button click event on cell | Excel Programming | |||
| Capture event when exit Column G | Excel Discussion (Misc queries) | |||
| Capture scrolling event | Excel Programming | |||
| capture paste event into a cell | Excel Programming | |||
![Vinit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
