Programmatically Docking Toolbars

G

Guest

Is it possible to define where a toolbar is docked in a Excel window? I have
a custom defined toolbar that holds icons for a number of functions in my
system. I would like to have to toolbar appear docked at the bottom of the
screen just above the start menu. Is that at all possible in VBA?

I can see the toolbar's OLE_Handle; is this something that needs to be done
using the Windows API?
 
T

Tom Ogilvy

commandbars("Custom 2").Visible = True
commandbars("Custom 2").Position = msoBarBottom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top