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

Рет қаралды 32,710

4 жыл бұрын

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.

Пікірлер: 55

@saxon_man 3 жыл бұрын

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 :)

@philipshpakowsky1712 3 жыл бұрын

Just what I was looking for. Thanks.

@s.m.rashedrony3515 3 жыл бұрын

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

@aquaicecold Жыл бұрын

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

@David_Flournoy 2 жыл бұрын

excellent presentation. Works perfectly Thank you

@querrythis 2 жыл бұрын

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

@two-lluis3695 Жыл бұрын

I loved it, you won a new subscriber

@enninsimon1588 3 жыл бұрын

thanks you made my day

@sinanbasha-2564 2 жыл бұрын

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

@ihthram Жыл бұрын

Appreciated very good video❤

@harsh27parasiya 3 жыл бұрын

excellent sir

@Wenielyn 2 жыл бұрын

Si nice. Thank you so much😃

@shaunenricofrancis9479 3 жыл бұрын

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.

@yassbadiane2053 Жыл бұрын

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

@fbfoot4921 2 жыл бұрын

Super

@arorasuneet 2 жыл бұрын

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

@syedimran9406 Жыл бұрын

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

@yourownson2724 3 жыл бұрын

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

@calebpecue6923 2 жыл бұрын

Sorry for the delay in responding. I haven't received this error. What precisely does it say?

@NMTechMaster Жыл бұрын

Nice

@pradana1908 2 жыл бұрын

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

@bertvantol9669 2 жыл бұрын

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

@calebpecue6923 2 жыл бұрын

I don't have a download of this, at the moment.

@TorqueDemo 2 жыл бұрын

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?

@stvdeclercq 3 жыл бұрын

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

@reagentjtv5358 3 жыл бұрын

Great trick.. having the same issue.. the hide settings also applies to every other excel file I open.. need solution to this..

@vincentdublin3127 2 жыл бұрын

just do the reverse and put the code in workbook_deactivate

@calebpecue6923 2 жыл бұрын

@@reagentjtv5358 I believe there are ways to handle it applying to other workbooks. I believe it may have to do with calling something PRIVATE. I will have to research it. For me, I only open this workbook while others are closed. In my admin area of my workbook I have a toggle to unhide everything if in the event I did have another excel open.

@maxrex22 2 жыл бұрын

I had the same problem. Other workbooks inherited this functionality and the ribbon/tabs/scroll bars are all missing. I tried running the macros to unhide the items in other workbooks and they don't work, so I have to go into the file I originally ran the macro, open VBA..run the macro to unhide everything and then all my other workbooks are back to normal. I'd really like to know how to limit these macros to just the one workbook.

@veebee3969 2 жыл бұрын

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.

@jeanbaron2356 2 жыл бұрын

If you have lost the UI, press Alt F11 to open VBA editor and run the ShowUI sub (create it if you did not before). It should restore everything.

@calebpecue6923 2 жыл бұрын

As Jean said, it is easy to create a button in the admin area that allows you to unhide everything if you need to.

@VijayKumar-zd7ou 3 жыл бұрын

Sir, how to many shapes hide and visible timing through like animated effect show VBA through in excel please upload regarding this video.

@calebpecue6923 2 жыл бұрын

Sorry, I am not sure what your question is. Are you trying to hide shapes? If so, I have another video on that.

@pragabryson5074 3 жыл бұрын

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

@calebpecue6923 3 жыл бұрын

The icon in the corner, not that I am aware of; however I do have a special icon for my app on my desktop. It is made by changing the icon of a shortcut.

@lintamathew4960 3 жыл бұрын

Hi is there any option for hide in filter i tried '.visible=false'

@calebpecue6923 2 жыл бұрын

What are you trying to hide?

@AgentschapTD 2 жыл бұрын

Could you share the file?

@pedrobueno4848 Жыл бұрын

Thank You

@faraznaeem9013 3 жыл бұрын

How to hide after changes?

@calebpecue6923 2 жыл бұрын

You want to hide the bars only after you change something in the excel?

@excelforfun1997 3 жыл бұрын

Why not copy paste and find replace false with true ?

@calebpecue6923 3 жыл бұрын

That would work. When I made these videos I was accessing word on a vpn because my mac doesn't handle the coding stuff (thanks Apple). So copy/paste doesn't work across platforms in the remote viewer. It would work in other cases though

@excelforfun1997 3 жыл бұрын

@@calebpecue6923 i like the code I'm going to use it many times

@davidgarrad5393 3 жыл бұрын

Could you clarify how to turn the column and row headers on and off plz. I have used some of your code but they seem to be doing their own thing. Ta

@calebpecue6923 2 жыл бұрын

Did you follow it exactly? Mine doesn't do its own thing.

@jagadishshirsath5268 Жыл бұрын

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