HIDE MENU RIBBON AND APPLICATION MENUS

[marne1]

I want to be able to open an excel file and not show the menu ribbon or quick tool bar. Basically, I just want to see the spreadsheet only.

I use Excel 2007.

 

[GlennUK]

How does full screen look in 2007? To try it do this:

To view more data on the screen, you can temporarily switch to full screen view. Full screen view hides the Microsoft Office Fluent user interface Ribbon, the formula bar, and the status bar. To have access to the hidden elements again, you have to return to normal screen view.

To switch to full screen view, on the View tab, in the Workbook Views group, click Full Screen.

To return to normal screen view, right-click anywhere in the worksheet, and then click Close Full Screen.
Keyboard shortcut You can also press ESC

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[tf1]

To hide the Ribbon, switch to AutoHide mode by:

Double-click the Ribbon or
Use Ctrl+F1 or
Click the little arrow at the right-hand end of the Ribbon
Right-click the Ribbon and chose, Minimise the Ribbon.

Using any of these again will toggle off the AutoHide mode.

Or go to Full Screen View:

Alt+W, E

To exit FSV, press ESCape key.

Note 1: You can add the FSV command to your QAT.
Note 2: If you display the QAT above the Ribbon, it will not take up any additional space.




Regards: Terry

 

[marne1]

Thank you, I will try this, but I don't really want to be using full-view. This file is opening in a web-browser, is there some code to keep it from opening the menu tabs and ribbon menu? In the XML code?

 

[tf1]

I'm sure that an AutoOpen macro attached would toggle Hide Ribbon on.

Regards: Terry

 

[TonyJollans]

What you can do inside a browser is limited, and you may not be able to run VBA code, or hide the ribbon.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[marne1]

Thank you everyone. I am able to view full screen, but isn't gonna work in this case.


Thanks Tony, I will keep looking for a way -- was hoping maybe in XML code if not VBA.