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
 
P

Patrick Molloy

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

Can I edit macro buttons on the quick access toolbar in excel? 0
How to Capture Edit Cell Event? 3
Word macro that can call cells out of Excel for a find and replace 0
menus & Commandbars disable when double click on cell/formula bar 0
Change cell backgrounds from VBA with undo enabled 3
How to enable / disable ControlButton added to Cell CommandBar 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

Top