How to Hide Excel and Show Userform ONLY 2022 (No Excel Splash Screen) ExcelVbaIsFun

Рет қаралды 47,939

Күн бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
This video is a follow-up from an older video on this channel wherein we were able to hide Excel’s application and all sheets completely (even from the Taskbar) and only showed Userforms. This gives the look and feel of a compiled windows application written using Visual Studio or other platforms.
In today’s video, we’re learning how we can also remove the Excel loading splash screen using my favorite Excel security app, XLSPadlock.
Learn more about XLSPadlock: www.excelvbaisfun.com/lock
So in this case, we're actually going to have it automatically hide. Whenever the workbook opens before the Userform even shows we want to hide the application so we're really trying to pretend this is not Excel in this case.
So we’re still going to use Application.Visible = False. Then we save and reopen it and you'll see that it still has the excel loading screen.
In this video, I want to show you some magic powers that you can have whenever you have XLSPadlock. XLSPadlock is a compiling application that allows you to create windows executables or .EXE files - actual applications that protect your Excel data and it has a lot of other features as well. One of them is the ability to hide that loading screen and have your own custom splash screen for your application. We’re going to go very basic in this video, but we cover every feature in our full-length course on the program.
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/
00:00 Intro
00:33 Making a Userform
00:45 Using the Toolbox
00:55 Hiding Excel Application (code example)
01:26 Unhide Excel button
01:48 Load UF & hide Excel when Workbook Opens
02:20 What if you don't want to show Excel Splash Screen?
03:17 Using XLSPadlock to save Excel as EXE
03:50 Customize Loading screen settings
04:10 Compile EXE file from Excel
05:55 Load Excel minimized and no delay
06:32 Demonstrating NO EXCEL SPLASH SCREEN
07:30 Become an Excel Ninja
08:22 Other Videos and Resources

Пікірлер: 33

@JonathanSteadman2003 Жыл бұрын

Thanks this helped me with my college assignment when I needed to hide the spreasheet data but need to show the form for people to interact with. :)

@eoinlundy 2 жыл бұрын

Thanks Dan, amazing work.

@ExcelVbaIsFun 2 жыл бұрын

Thanks, Eoin! I appreciate it! More to come, my friend. 😃

@wayneedmondson1065 2 жыл бұрын

Hi. Cool option to make for a clean project load. Thanks for sharing. Thumbs up!!

@ExcelVbaIsFun 2 жыл бұрын

Thanks, Wayne!!! I'll do another one on how to make a custom splash screen soon. It's super easy. :)

@thomasfergusen5144 2 жыл бұрын

Amazing! Thanks very much

@ExcelVbaIsFun 2 жыл бұрын

Very welcome, thomas. More to come on that topic soon

@azhadshamim3122 2 жыл бұрын

This code working effectively first time but second time Excel is opened So 50/50

@hassanjatta4257 2 жыл бұрын

Thanks for sharing.

@ExcelVbaIsFun 2 жыл бұрын

Very welcome, Hassan. Thanks for the comment! :)

@nunyabusiness4516 Жыл бұрын

I am quite intrigued. I would like to learn more about the XLS Padlock. Where can we take courses on this to develop an application? Please advise. Thank you in advance.

@blinkwinkenterprises8056 2 жыл бұрын

Thank you sir, actually am having a hard time to create something like this but you have done an amazing work here.

@ExcelVbaIsFun 2 жыл бұрын

Hey there, thanks so much! What exactly are you having a hard time with, maybe we can help. Thanks Dan

@blinkwinkenterprises8056 2 жыл бұрын

It's a login page sir

@ExcelVbaIsFun 2 жыл бұрын

@@blinkwinkenterprises8056 oh, I see, you're creating a login page with a Userform and trying to make it only use a Userform and suppress Excel application? Gotcha.

@blinkwinkenterprises8056 2 жыл бұрын

Yes prof. If you would not mind please let me have your email sir let me send you my project and you will help! I want to submit it on Friday sir please. Thanks alot

@ExcelVbaIsFun 2 жыл бұрын

@@blinkwinkenterprises8056 Hi there, you can send to admin@excelvbaisfun.com if you want, and I'm happy to take a quick look, but I don't do people's homework or work for free if it's extensive. Thanks for understanding. Dan

@abdulhayee5902 Жыл бұрын

Hi. This is very great tutorial and I was looking about this and found your tutorial very helpful. I have a question regarding excel VBA. Can I discuss it here or somewhere else? kindly do tell me

@JPOuweltjes 7 ай бұрын

Why not joining one of the many VBA forums?

@Shady_Lane 2 жыл бұрын

very cool! however.. do you know a work-around for scenarios where you might want to edit a different Excel sheet while the userform is open? Would this functionality even allow you to open another spreadsheet?

@ExcelVbaIsFun 2 жыл бұрын

Hi Shady Lane, Yes, there are ways to get this functionality. You can have specific workbooks or windows to hide when you need instead of the entire application. This gets busier when you want them to be able to use the Userform OR the other workbooks as you have to make the form non-modal and then it gets busier still when you want to close the other workbook, because this seems to want to close both workbooks. There are methods we can employ to handle these, but there are some things to be aware of. Planning a mini-course to combat these struggles as we speak. :)

@ragnarok7976 Жыл бұрын

@@ExcelVbaIsFun Application.Window(ThisWorkbook.Name).Visible = False That will hide the window that the macro is running under

@danp6101 2 жыл бұрын

Hey Dan. How did you get all the extra tool commands in your toolbox. I was wonder could you do a video on making a Class module using with events. Example I'm Making a Userform With Multiple Labels and textboxes. I add them Dynamically when the Useform opens up with the Initialize event. I want to be able to use Mouse Move event and the Click event for the labels and textboxes. I Don't know how to get the with events to work properly with the Class Module. I hope You understand what i'm trying to say.

@ExcelVbaIsFun 2 жыл бұрын

Hey Dan! The extra tools are from other ActiveX control I have, some of which are specialty control like the new Grid control I've been covering on my channel. I can send you some links! As for the class modules, ill put it on my (extensive) to-do list 🙂. Will do

@mark99k Жыл бұрын

I was barely paying attention during the first part since I've seen that trick before, but then XLS Padlock had me salivating. Can I assume the resulting executable runs regardless of whether it's in a VBA "trusted location"? (Am guessing yes since the macro code isn't actually even there anymore.)

@ExcelVbaIsFun Жыл бұрын

It does make the motw issue clear up. You still can get warnings from Microsoft until you code sign the EXE. Give the free demo a try: www.excelvbaisfun.com/xlspadlock