Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Display Chart page in fullscreen

1,567 views
Skip to first unread message

bart de reu

unread,
Apr 28, 2003, 2:10:09 PM4/28/03
to
Hi,

Does someone know how to get a chart page into
real fullscreen? when i try, even with vba, i can't
get rid of the menu bar.

Help Help
i've being trying so hard but i couldn't find the way
to erase it...

Thnx

Tushar Mehta

unread,
Apr 29, 2003, 5:28:36 AM4/29/03
to
Interesting...

With XL2002, the best I can do is to move the Chart Menu Bar so that it
floats. Apparently, there is no way to get rid of it. It is not
listed in the list of command bars shown in a right-click context menu
and VBA code Application.CommandBars ("Chart Menu Bar").Visible=False
fails with a 'Visible method of _Commandbar object failed."

[The same seems to apply to a worksheet. Full Screen in XL seems to
include the top command bar. In addition, if the sheet tabs at the
bottom are visible, they remain so in Full Screen mode]

--
Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP -- Excel

In article <019501c30db1$67c21150$a301...@phx.gbl>,
bart...@pandora.be says...

Jon Peltier

unread,
Apr 29, 2003, 8:16:51 AM4/29/03
to
With Menu Bars, you need to use a command like this:

Application.CommandBars("Chart Menu Bar").Enabled = False

or

Application.CommandBars("Worksheet Menu Bar").Enabled = False

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

0 new messages