Automatically Hide Excel Menus, Bars, Etc Upon Opening using Excel VBA Code to Look Like an App
HTML-код
- Опубликовано: 17 сен 2024
- 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.
Great job! Just what I needed. Thanks mate :)
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 :)
Your videos really help me
Thanks so much. More power and God bless!
Just what I was looking for. Thanks.
I loved it, you won a new subscriber
I did enjoy this training! How did you become an Excel genius?
Lol, I'm not. Just watched some videos.
Mr. Pecue, Thanks a lot, this is awesome to learn!
excellent presentation. Works perfectly Thank you
This is awesome. Very useful for me. Thanks a lot
WooOooW .. It's really nice tutorial .. thanks a lot
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.
Appreciated very good video❤
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
Could you please let me know how can I disable this specific command : View > Formula Bar in Excel 365 ? Thanks!
Super
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
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.
thanks you made my day
Si nice. Thank you so much😃
excellent sir
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?
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.
Thank You
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.
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.
How to hide after changes?
You want to hide the bars only after you change something in the excel?
Nice
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
Hi is there any option for hide in filter i tried '.visible=false'
What are you trying to hide?
Great tutorial, btw how to hide entire ribbon but leave the top quick acces still shown. Thanks before :)
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.
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.
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?
my file was corrupted after i put the codes.
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