Automatically Hide Excel Menus, Bars, Etc Upon Opening using Excel VBA Code to Look Like an App

In this training I walk you through the steps of setting up your workbook so that it hides all of the menus and bars upon opening. This will create a workbook that looks like an application, rather than excel. It can also help to prevent your users from changing any of the formatting. This also does not have to be in Full Screen as a lot of other trainings show.

[mario]

Great job! Just what I needed. Thanks mate :)

[saxon_man]

Brilliant. This covers pretty much everything I will ever need, ahd has opened my eyes to see what else Excel has to offer. Thank you :)

[aquaicecold]

Your videos really help me
Thanks so much. More power and God bless!

[brentsrx]

I did enjoy this training! How did you become an Excel genius?

[s.m.rashedrony]

Mr. Pecue, Thanks a lot, this is awesome to learn!

[David_Flournoy]

excellent presentation. Works perfectly Thank you

[querrythis]

This is awesome. Very useful for me. Thanks a lot

[yassbadiane]

Caleb, this is a wonderful tool. I wrote the code and it worked but now I can't unhide the menu bars etc. Please help! Thank you

[shaunenricofrancis]

Thanks for this awesome code. I have applied to my app and it worked perfectly. I 'm busy applying security layer to the app. My problem is: when I apply standard security, the active pdf object is also locked. Should I apply a vba as security and enable the objects. I'm not sure how to do this.

[syedimran]

Awesome sir useful but I have a one question
After hide Menus bars etc I have tu open my workbook full screen not this size how can I do that could you help me please
.width 845
.height 408

[arorasuneet]

Could you please let me know how can I disable this specific command : View > Formula Bar in Excel 365 ? Thanks!

[sinanbasha-]

WooOooW .. It's really nice tutorial .. thanks a lot

[stvdeclercq]

Hi Caleb, great content.
I got 2 Issues
1. When I open the file it still displayd the (collapsed) menu bar. The same with the statusbar.
2. Some of these settings translated back to other excel files (who don't have the code), like the hiden scrollbars, the collapsed menu bar, the hiden formulabar...

I can't find a way to isolate the settings to just this workbook and not as general settings.

You got an idea? Thank you in advance

[TorqueDemo]

Hello,
We had an employee leave the company and he revised all of our templates. We use many. HE did great work however he removed all of the menus and ribbons etc. I tried to open VBA and its passworded. my only option now id to re create them. IS there a way to crack that password?

[yourownson]

This is very awesome.. I wonder why I have automation error when I copy your codes? Anynsuggestion?

[pradana]

Great tutorial, btw how to hide entire ribbon but leave the top quick acces still shown. Thanks before :)

[veebee]

Thanks Caleb. On some websites, there were comments that "if windows crashes while the 'toolbars', 'ribbon' etc. are hidden, then they will be lost forever and one cannot ever regain control of Excel". Is this true? If windows crashes, on restarting the computer and restarting Excel, will I be able to see 'toolbars' and 'ribbon' again? Appreciate your advice.

[bertvantol]

Do you have a download for your Excel-sheet ??
and / or a manual with all the code ??

[jagadishshirsath]

Sir My VBA Applicatoin File Run Time After Click Menu Bar This Problem Create Plz see This
excel Working Has Stop Working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is Available

sir Any Solution So Plz Reply

[pragabryson]

If it's possible to change the logo of excel by another one?