This is a bit of a wierd one. I have an application that i open with no
toolbars and menu disabled so it is totally without and real estate. It's
fine until I start clicking an option button which switches to the next
sheet which is a chart with the same lack of real estate. When I do I get a
bar (like the menu bar with no menus) appear across the top. It wouldn't be
that bad but it appears in front and blocks the top bit of a group of
buttons so anyone know how I would prevent it fronm appearing?

Thanks for your help Mark

Hi Mark
Not a solution but I have a similar problem, I leave the main menu on, no
toolbars but there is a custom toolbar I create that sits underneath the
main menu. Until I activate a chart sheet and the main menu and custom
toolbar change places, activating a worksheet and they switch back.- quite
bizarre. Not really figured out what is going on but sounds like your
problem is similar in nature.

Maybe we will both get some insight from the NG ?

--
Cheers
Nigel



"Mark Stephens" wrote in message
...
This is a bit of a wierd one. I have an application that i open with no
toolbars and menu disabled so it is totally without and real estate. It's
fine until I start clicking an option button which switches to the next
sheet which is a chart with the same lack of real estate. When I do I get
a
bar (like the menu bar with no menus) appear across the top. It wouldn't
be
that bad but it appears in front and blocks the top bit of a group of
buttons so anyone know how I would prevent it fronm appearing?

Thanks for your help Mark

When a chart has the focus, the Worksheet Menu Bar is replaced with the
Chart Menu Bar

? commandbars(1).Name
Worksheet Menu Bar
? commandbars(2).Name
Chart Menu Bar

So I suspect you need to disable the Chart Menu Bar

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
Hi Mark
Not a solution but I have a similar problem, I leave the main menu on, no
toolbars but there is a custom toolbar I create that sits underneath the
main menu. Until I activate a chart sheet and the main menu and custom
toolbar change places, activating a worksheet and they switch back.- quite
bizarre. Not really figured out what is going on but sounds like your
problem is similar in nature.

Maybe we will both get some insight from the NG ?

--
Cheers
Nigel



"Mark Stephens" wrote in message
...
This is a bit of a wierd one. I have an application that i open with no
toolbars and menu disabled so it is totally without and real estate.
It's
fine until I start clicking an option button which switches to the next
sheet which is a chart with the same lack of real estate. When I do I
get
a
bar (like the menu bar with no menus) appear across the top. It wouldn't
be
that bad but it appears in front and blocks the top bit of a group of
buttons so anyone know how I would prevent it fronm appearing?

Thanks for your help Mark

Tom
You have solved my problem - as usual, thanks very much.

It was indeed the exchange of toolbars that caused the problem.

--
Cheers
Nigel



"Tom Ogilvy" wrote in message
...
When a chart has the focus, the Worksheet Menu Bar is replaced with the
Chart Menu Bar

? commandbars(1).Name
Worksheet Menu Bar
? commandbars(2).Name
Chart Menu Bar

So I suspect you need to disable the Chart Menu Bar

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
Hi Mark
Not a solution but I have a similar problem, I leave the main menu on,
no
toolbars but there is a custom toolbar I create that sits underneath the
main menu. Until I activate a chart sheet and the main menu and custom
toolbar change places, activating a worksheet and they switch back.-
quite
bizarre. Not really figured out what is going on but sounds like your
problem is similar in nature.

Maybe we will both get some insight from the NG ?

--
Cheers
Nigel



"Mark Stephens" wrote in message
...
This is a bit of a wierd one. I have an application that i open with
no
toolbars and menu disabled so it is totally without and real estate.
It's
fine until I start clicking an option button which switches to the
next
sheet which is a chart with the same lack of real estate. When I do I
get
a
bar (like the menu bar with no menus) appear across the top. It
wouldn't
be
that bad but it appears in front and blocks the top bit of a group of
buttons so anyone know how I would prevent it fronm appearing?

Thanks for your help Mark