Right Click Menu

Question

In my new Excel I notice that 2 commandbars appear when right-clicking. The Bottom one has Index 35 ("cell"). I can not figure out

the Index of the above one, which I want to make invisible, or make its controls invisible. It  contains Font Types, money type, percent etc.

In controls list of particular commandbars some of these controls are located in Formatting commandbar. I cannot eliminate the controls one by one either, since their names miss, and they do not exist under 35 anyway. 

Anybody has any idea ?

Answer 1

I just stumbled on the answer then tested it.

Totally screwy, and non-intuitive.

The setting is

Application.ShowMenuFloaties

however

Application.ShowMenuFloaties = True

    actually sets the setting it to False.

Application.ShowMenuFloaties = False,

    if it is already False, toggles it to True.

    If it is True, it does nothing

Application.ShowMenuFloaties = Application.ShowMenuFloaties

     toggles it.

So, for any guarantee,  level the playing field with 

 Application.ShowMenuFloaties = True

    (which sets it False).

Then toggle it

   Application.ShowMenuFloaties = Application.ShowMenuFloaties

or not, as need be.

Sub ShowFloaties()   ' True = False, 2nd line toggles to True

Application.ShowMenuFloaties = True

Application.ShowMenuFloaties = Application.ShowMenuFloaties

End Sub

Sub Hidefloaties()   ' True = False

Application.ShowMenuFloaties = True

End Sub

Cheers -

 - glenn