View Single Post
  #5   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
...
Hi Rob,

When I try that, I get a compile error: "Expected variable or procedure,
not module". I have tried both ? commandbars(myapp).top and ?
commandbars("My Toolbar").top.


Hi Patti,

It sounds like you've named one of your code modules CommandBars. This
is confusing VBA because it thinks you're trying to reference a procedure in
that module. Rename the module to something like MCommandBars and try it
again.

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