View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
minimaster minimaster is offline
external usenet poster
 
Posts: 73
Default Screen position of commandbar button in Excel 2007 ?

My commandbar button isn't a popup in itself, its just a "simple"
commandbar button which calls a procedure that then dynamically
creates a fully independent popup menu. The problem is to have the
newly created popup menu show up right below the commandbar button in
order to give the illusion that the button behaves like a popup menu.
This approach worked fine in 2003 and was choosen because there is no
such thing like a "popup button" in the excel 2003 object model.
Because I have a simple commandbar button I don't need to reference
the parent. However the .top information isn't provided correctly in
2007. And I'm afraid your code snippets don't do it either in 2007.
Plus there is no such thing like a vertical arrangement for a
commandbar in 2007. All commanddbars are dispalyed horizontally
aligned under the Add-ins tab - or I'm missing something?