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

Top