Customizing context menus

[AutoFilterQueen]

I am running Excel 2013. Using VBA, I have customized the context menu so that when I right-click on a cell it shows only two options: Edit Name and Remove. However, above these two remaining options, there is a rectangle with buttons representing various formatting changes I could make to the cell: font, font size, bold, italic, font color, fill color, etc. I believe this rectangle did not exist in Excel 2007 but is present in Excel 2010 and 2013. Is it possible to get rid of this rectangle? If so, how? I don't know what it is called so I don't know what to search for. Thanks in advance for your help!

 

[Momentman]

Are you referring to the Mini Toolbar?

From File>Options>General - untick the checkbox beside "Show minitoolbar on selection"

 

[starl]

This may seem counter-intuitive, but

application.ShowMenuFloaties = True 'hides the minitoolbar
application.ShowMenuFloaties = false 'shows the minitoolbar

 

[AutoFilterQueen]

Yes, that's it! Thank you so much! I was actually looking for how to do this in VBA, but since you told me what it is called I was able to search for how to do it in VBA. The code to remove it is:

[FONT=Courier New]Application.ShowMenuFloaties = True[/FONT]

Here is the site where I found it. Tom’s Tutorials For Excel: Hide the right-click Mini Toolbar | Atlas I really appreciate your help.

 

[AutoFilterQueen]

Thanks to both of you! Problem solved.