Excel 2007 Application.ShowMenuFloaties Bug
 

Thought I'd share this with the group as it might help someone ...

The ShowMenuFloaties property changes whether the little floating mini
formatting toolbar appears above the right-click menu. True =
displayed, False = hidden ... as you'd expect!

Although this property is writeable, when you write to it, the results
seem to be the opposite of what you would normally expect.

For example:

Sub MenuFloaties()
Application.ShowMenuFloaties = True
MsgBox "ShowMenuFloaties = " & Application.ShowMenuFloaties
End Sub

This actually changes the property to False (yes, this isn't a typo)!

And ...

Sub MenuFloaties()
Application.ShowMenuFloaties = False
MsgBox "ShowMenuFloaties = " & Application.ShowMenuFloaties
End Sub

This changes the property to True (yes, this isn't a typo either)!

So ... you need to set the value of the property to the opposite of
what you actually want it to be.


Even more strange, the macro below toggles the property's value!

Sub MenuFloaties()
Application.ShowMenuFloaties = Application.ShowMenuFloaties
MsgBox "ShowMenuFloaties = " & Application.ShowMenuFloaties
End Sub


Hope this helps someone - it took me a while to figure this out!

Same result occurs for ShowSelectionFloaties.

Maybe the developers were originally intending to call these
properties "HideMenuFloaties" and "HideSelectionFloaties"?

Regards

Jeff Robson
www.accessanalytic.com.au