Automatically Hide Excel Menus, Bars, Etc Upon Opening using Excel VBA Code to Look Like an App
ฝัง
- เผยแพร่เมื่อ 7 ม.ค. 2025
- 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.
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 :)
Caleb, this video is great. I'd like to know if you can help me. I need to hide the Formula Bar and the Formula Bar checkbox, disable the Save As, have only the Save button, and give only the option of saving the file as a CSV. Do you have another video that shows this, or can you reply to this comment with the necessary code? Thanks.
Your videos really help me
Thanks so much. More power and God bless!
I loved it, you won a new subscriber
Great job! Just what I needed. Thanks mate :)
Could you please let me know how can I disable this specific command : View > Formula Bar in Excel 365 ? Thanks!
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
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?
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
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
Great trick.. having the same issue.. the hide settings also applies to every other excel file I open.. need solution to this..
just do the reverse and put the code in workbook_deactivate
@@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.
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.
Workbook Weight Height VBA code does not work. Please download the file
I don't know what you mean by your comment. If something doesn't work anymore it is because it's old. The video has been up for a few years and technology changes. Nowadays I work in Powerapps and less in VBA.
Do you have a download for your Excel-sheet ??
and / or a manual with all the code ??
I don't have a download of this, at the moment.
I did enjoy this training! How did you become an Excel genius?
Lol, I'm not. Just watched some videos.
Just what I was looking for. Thanks.
If it's possible to change the logo of excel by another one?
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.
Hi is there any option for hide in filter i tried '.visible=false'
What are you trying to hide?
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.
Mr. Pecue, Thanks a lot, this is awesome to learn!
This is very awesome.. I wonder why I have automation error when I copy your codes? Anynsuggestion?
Sorry for the delay in responding. I haven't received this error. What precisely does it say?
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.
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.
As Jean said, it is easy to create a button in the admin area that allows you to unhide everything if you need to.
How to hide after changes?
You want to hide the bars only after you change something in the excel?
Why not copy paste and find replace false with true ?
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
@@calebpecue6923 i like the code I'm going to use it many times
excellent presentation. Works perfectly Thank you
This is awesome. Very useful for me. Thanks a lot
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
Could you share the file?
Appreciated very good video❤
Sir, how to many shapes hide and visible timing through like animated effect show VBA through in excel please upload regarding this video.
Sorry, I am not sure what your question is. Are you trying to hide shapes? If so, I have another video on that.
WooOooW .. It's really nice tutorial .. thanks a lot
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
Did you follow it exactly? Mine doesn't do its own thing.
Great tutorial, btw how to hide entire ribbon but leave the top quick acces still shown. Thanks before :)
my file was corrupted after i put the codes.
thanks you made my day
Si nice. Thank you so much😃
excellent sir
Super
Nice
Would have been .even better if you had made code available to download. So basically this video is useless, unless you have really good memory.
Awesome job! What do you charge? I have a sheet that needs some work. Please let me know and I’ll send you my contact info
Thank You