Thread: Context Menu 2007/2010
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] usnewmansNOSPAM@charter.net is offline
external usenet poster
  
Posts: 13
Default Context Menu 2007/2010
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.
Reply With QuoteReply With Quote