Channel: ExcelVbaIsFun

Category: Education

Tags: excel vba is funexcel vba full courseexcelvbaisfunxlspadlockdan strongexcel protectionhide excel splash screenexcel securityexcel vbaexcel compilerdaniel strong vba

Description: 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: 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. Excel to EXE (Full XLSPadlock Course): excelvbaisfun.com/product/excel-to-exe-make-secure-windows-applications-from-excel/?utm_source=youtube&utm_medium=desc&utm_campaign=How%20to%20Hide%20Excel%20and%20Show%20Userform%20ONLY%202022%20No%20Excel%20Splash%20Screen Join Excel Ninjas FB Group: excelvbaisfun.com/ninja 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 Get My Bestselling Excel VBA Courses: Excel VBA Essentials Course: bit.ly/UltExcelVBA Control Websites With Excel VBA: bit.ly/VbaWebAutomation Speed Up Code With VBA Arrays: bit.ly/VbaArrays Create Your Own Functions/Addins: bit.ly/CustomUDFsAddins Fill PDFs/Forms with Excel VBA: bit.ly/VbaPDFsMastery Excel VBA Barcode Lookup System & Inventory Projects: bit.ly/VbaBarcodesProjects Instantly Secure Excel Files; Transform Into EXE Programs!: bit.ly/Excel2EXE Automate Outlook with Excel VBA: bit.ly/ExcelVBAOutlook Professional Animations In Excel by Kishon: click.linksynergy.com/deeplink?id=BYzUIhHF1Ys&mid=39197&murl=https%3A%2F%2Fwww.udemy.com%2Fmicrosoft-excel-animation-for-great-user-experience%2F Fantastic Developer Tools: Lock Any Workbook Into An EXE (Software only, see course above): excelvbaisfun.com/get-xlspadlock Create Custom Installers: excelvbaisfun.com/get-pb Free Ebook: excelvbaisfun.com/FreeEbook Dan Strong's Articles: excelvbaisfun.com/blog Free Excel Workbooks: excelvbaisfun.com/free-workbooks Business Inquiries, Consulting, Comments, etc: excelvbaisfun.com/contact ExcelVbaIsFun YouTube Playlists: Excel Vba Basics: bit.ly/ExcelVbaBasicsPlaylist Tips N Tricks: bit.ly/VbaTipsNTricksPlaylist Userforms: bit.ly/ExcelVbaUserformsPlaylist Events Series: bit.ly/VbaEventsPlaylist Activex Controls: bit.ly/VbaActiveXPlaylist Sample Excel Programs: bit.ly/SampleExcelPrograms Where else you can find me: LinkedIn: linkedin.com/in/danielcstrong Facebook: facebook.com/Excelvbaisfun Twitter: twitter.com/ExcelVbaIsFun Google Plus+: google.com/+ExcelVbaIsFun T-Shirts/Merch: ExcelVbaIsFun.spreadshirt.com 'Royalty Free Music by audiomicro.com/royalty-free-music' Image by Clker-Free-Vector-Images (pixabay.com/users/clker-free-vector-images-3736/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=39767) from Pixabay