Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

Application.ShowMenuFloaties Property

Office 2007
Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. False if Mini toolbars are displayed. Read/write Boolean.

Version Information
 Version Added:  Excel 2007

Syntax

expression.ShowMenuFloaties

expression   A variable that represents an Application object.


See Also


Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Unexpected Behavior

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"?

History