On Sat, 22 Jan 2011 19:23:35 -0500, GS wrote:
brought next idea :
On Sat, 22 Jan 2011 12:24:31 -0500, wrote:
There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.
I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.
I would appreciate any help offered.
Thank you.
Found it, but the syntax does not seem logical...
Application.ShowMenuFloaties = True to hide the Mini Toolbar
Application.ShowMenuFloaties = False to show it.
Jim's reply handles the "floaties" menus. Not sure why you'd go to the
trouble of deleting all the menus on the "Cell" popup when you could
just set its 'Enabled' property to "False" to prevent it from showing.
I knew after I posted this question that I hadn't provided enough
information. My error.
I suppose if I'd been more specific by mentioning I had created menu
items for the right click event I would have answered that question
before it was asked.
Enabled = False also turns off my menu.