Programmatically Docking Toolbars

[Robert Mulroney]

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?

[Tom Ogilvy]

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


--
Regards,
Tom Ogilvy

"Robert Mulroney" <''''[email protected]''''> wrote in message
news:[email protected]...
> 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?

[Robert Mulroney]

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" <''''[email protected]''''> wrote in message
> news:[email protected]...
> > 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?
>
>
>