View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Get floating CommandBar position

"Patti" wrote in message
...
After I manually move my custom command bar to the place I want it, is
there a command I can type in the immediate window to get the .Top and
.Left positions?


Hi Patti,

Here's one way to do it:

? CommandBars("YourBarName").Top
? CommandBars("YourBarName").Left

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm