Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting to Excel 2007 format from asp.net application | Excel Discussion (Misc queries) | |||
application.filesearch error in excel 2007 | Excel Programming | |||
Application.Quit in Excel 2007 | Excel Programming | |||
Opening Excel 2007 application | Excel Discussion (Misc queries) | |||
Automating An Excel 2007 Application using VB | Excel Programming |