• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to hide the menu bar in excel

Hi, webmax!
VBA is part of Excel as well as cells and formulas. AFAIK there's no "formula" that could do that.
Regards!
PS: I want 100 million Pounds (£), not just a few bucks.
 
Hi Shahul ,

Do you mean Full Screen mode ? If so , the option is in the View tab ; in full screen mode , pressing the Esc key will bring you back to the normal windowed mode.

Narayan
 
Hi, webmax!
Or did you tried to mean doing it from the Excel window instead of the VBA window? If so, just place the code into a Sub procedure in any standard module, and then from Excel press Alt-F8 and select that procedure from the macro list. Or assign it to a command button and click on it from anywhere within the worksheet area.
Regards!
 
hi,

I want to hide all the menu bars like title bar,ribbon, formula bar.

I want only the cells this for purpose of keeping online test.
 
Hi Webmax, do you mean customizing the ribbon?

If you want only the cells to be shown,
1) Goto View tab -> Uncheck options Formula Bar & Headings to hide .
2) Right click on any ribbon -> Choose Customize the ribbon (Also can do this through File -> Options-> Customize Ribbon) -> under Main tabs section, uncheck all.

This should leave only the excel cells to you. Get the candidate onto the test. If he/she unhides all of this, pick them up :D

Remember all these custom settings will be under Excel.officeUI at the location appdata\local\microsoft\office.
 
You must log in or register to reply here.
Back
Top