Commandbars in Excel 97 1

[ChrisBurch]

I have a workbook where I have removed all the standard commandbars via code, and then add my own menu. All is working okay, except that my new menu appears as a floating bar. How can I get this to 'park' at the top of the screen?

Thanks for any help.

Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[nesplb]

Hi Chris!
Maybe you can Apply this code to position th menu at the top?

Application.CommandBars("BarName&quot.Enabled
Application.CommandBars("BarName&quot.Position = msoBarTop

 

[ChrisBurch]

Thanks, just what I needed.

Chris

It worked yesterday.
It doesn't work today.
That's Windows!