Pixelpusher
10-22-2009, 04:59 AM
Hi all.
I have a custom menu that I call on loading and hide standard menus returning on closing workbook. The problem is I can not get my menu to position top left on opening it just floats in the middle. I have tried this code below but nothing. Any ideas please.:banghead:
Option Explicit
Sub Make_ChartToolbar_Float()
With Application.CommandBars("Wade")
.Left = 10
.Top = 200
.Protection = msoBarNoProtection
.Visible = True
.Position = msoBarFloating
End With
End Sub
Thanks
I have a custom menu that I call on loading and hide standard menus returning on closing workbook. The problem is I can not get my menu to position top left on opening it just floats in the middle. I have tried this code below but nothing. Any ideas please.:banghead:
Option Explicit
Sub Make_ChartToolbar_Float()
With Application.CommandBars("Wade")
.Left = 10
.Top = 200
.Protection = msoBarNoProtection
.Visible = True
.Position = msoBarFloating
End With
End Sub
Thanks