Screen position of commandbar button in Excel 2007 ?
In your OP you said you have a popup menu which I took to mean a popup
commandbar (btw controls are shown vertically on those) and that's what the
example was aimed at. Ie, call the function from a button on a popup
commandbar. For me it worked fine in both 2003 and 2007, actually I thought
rather well!
If it's not a popup, explain what you mean, I don't follow what you describe
below (if not a popup). Better still post the code to create whatever it is.
Note, although popups work in Excel 2007 normal commandbars don't.
Regards,
Peter T
"minimaster" wrote in message
...
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?
|