Disable CommandBar buttons while editing the cell

V

Vinit

Hi Friends!!

When we edit the cell Excel disables the many button on Standard &
Formatting toolbar(new, open, and function etc..). I want to Disable
my CommandBar buttons while editing the cell. Can you tell me how to do
that?

Regards,

Vinit
 
G

Guest

Its not possible. You would have to raise an event when going into edit mode.
At this time, there is no such event available.
If you made it so that the only way to enable edit was to say use the right
click event, then you could use that event to call code that disables
buttons..but its quite tedious to do that.
 

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

How to Capture Edit Cell Event? 3
How to exec a commandbar button while cell in edit mode 1
How to exec a commandbar button while cell in edit mode 1
How to enable / disable ControlButton added to Cell CommandBar 3
The same event handler for two CommandBar buttons 6
Add standard button on custum commandbar 6
Change cell backgrounds from VBA with undo enabled 3
Identifying commandbar names in non-English versions of Excel 12

Top