Customizing (Hiding) Right Click Toolbar

[Dragonmann]

I am working on a new workbook to handle data in a very specific way. AS a result I am trying to limit the options available to the users, and programmatically force proper behavior. Since I don't have enough free time to smack knuckles with rulers as appropriate.

I have successfully customized the right click menu, and can hide the ribbon, but when they right click on a cell, they still get the little pop-up formatting toolbar.

I have tried searching for a way to hide this toolbar, but since I can't even figure out what the annoying little thing is called it has been less then successful.

Anyone know how to hide this thing, or at least what it is called?

 

[RoryA]

I think you want:

application.ShowMenuFloaties = true

note: this hides them, even though you would think it shows them!

 

[Dragonmann]

MenuFloaties?

FLOATIES?



WHY?

I would never have guessed that in a million years...

Thanx, that did exactly what I needed it to

 

[RoryA]

The name is relatively logical. Why you set ShowMenuFloaties to true to not show them, is beyond me.