Docking XL Toolbar 1

[RonRepp]

Hi all:

Is there a way in VBA to dock a toolbar? I've searched the forum and XL's help and found nothing.

Thanks,

Ron

Ron Repp

 

[rmikesmith]

Ron,

Application.CommandBars(TB_NAME).Position = msoBarLeft

Will dock a toolbar with the name contained in TB_NAME to the left side of the XL Window. Some additional Position constants are:

msoBarRight
msoBarTop
msoBarBottom

Regards,
Mike

 

[RonRepp]

Mike:

That's exactly what I needed.

Thanks,

Ron

Ron Repp