Programmatically Docking Toolbars
 

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?

Programmatically Docking Toolbars
 

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


--
Regards,
Tom Ogilvy

"Robert Mulroney" '''' wrote in message
...
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?

Programmatically Docking Toolbars
 

Cheers Tom. You always have the answers I need.

- Rm

"Tom Ogilvy" wrote:

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


--
Regards,
Tom Ogilvy

"Robert Mulroney" '''' wrote in message
...
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?