Course Information
Course Overview
Go Beyond Excel's Built-In Security Tools, Boost Features, Lock Down & Create Windows Applications (EXE) with XLSPadlock
Microsoft Excel is the most widely used software for business and personal projects, ranging from simple calculators and models to advanced dashboards and even enterprise level applications with advanced forms and procedures! But while Excel is rich in features and Easy to use, it lacks one major component. SECURITY.
Excel passwords were designed to prevent accidents & user-error, but can easily be retrieved with cheap password cracking software.
In my course, I show you how to turn your Excel workbooks into actual Windows Executable programs (EXE FILES) using my secret Excel weapon – XLSPadlock! This course includes a complete walkthrough of XLSPadlock along with little known Excel security techniques.
At the basic level, we’ll protect your Content from theft with unique formula protection techniques and then learn to convert your confidential VBA code into binary and store it in the executable, making it impossible to discover!
Then, we’ll learn about Licensing and Locking your Secure Application with:
Activation keys
USB/dongle protection
Hardware locking (to a particular PC)
Using a key generator to create trial versions of your software that expire after a number of
uses
days or
specific expiration date
and even create a nag screen each time the trial version opens!
You’ll learn Advanced Save Options (such as) whether users can use secure save files (that only work with a licensed copy of your EXE) OR to disable saving entirely!
You can control which Excel versions are allowed, and can build 32-bit, 64-bit or BOTH binary types into a single EXE!
I’ll teach you how to restrict native Excel features, like right-click options, copy/paste, removing excel ribbons, controlling add-ins allowed, disable Visual basic access a number of ways.
I'll demonstrate all the EXE Customizations, including making a professional splash screen that pops INSTEAD of the 'Excel loading' dialogue, creating and implementing custom icons, and customizing EXE version, title, authorship and copyright info.
We’ll demo how to make a simple End User License Agreement that MUST be accepted before someone can use your app! Lastly, we'll take you through adding a Code-Signing Certificate to show end-users your software is from a Trusted Verified Publisher.
I'm also including special code samples you can use to interact with the EXE to access hidden companion files, read version info or even interact with other Windows files or workbooks in a secure way.
You’ve got to protect your proprietary content!
Don't distribute another Excel file without maintaining absolute control of who’s using it and how - Grab my course on Building Secure Excel Apps today!
Course Content
- 9 section(s)
- 56 lecture(s)
- Section 1 Introduction
- Section 2 Protection With XLSPadlock - First The Basics
- Section 3 Advanced Licensing Features
- Section 4 Secure Save Files
- Section 5 App Settings and File Management
- Section 6 Advanced Security Settings
- Section 7 Customize EXE
- Section 8 Special Tips, Tricks and Macros
- Section 9 BONUS
What You’ll Learn
- Create Secure Windows Application (EXE files) Directly From Your Excel Workbooks!
- Super Protect Your Excel Formulas Beyond Excel Native Functionality
- Convert VBA To Binary Code, Hidden within the EXE
- Create Activation Keys For You App So You Control Who Can Use It (and How Long)
- Master Advanced Licensing Features
- Hardware Lock Your Application To a Particular PC
- Enable Dongle/USB Protection
- Set Up a 'Nag Screen' and Demo/Trial Modes with Expiration Date, Number of Uses or Days!
- Optionally Allow Users To Save Secure Encrypted Files, Only Usable with Licensed EXE
- Control Excel Versions Your App Will Open With (Office 2000 and up!)
- Build EXE for 32-bit, 64-bit or Universal EXE That Works With Any Excel Bitness!
- Access External Files Using Special Codes or Simple Hyperlinks
- Utilize Hidden Companion Files, Buried Deep In Your EXE
- Disable Visual Basic Editor or Locl the Project BEYOND Excel Native Capabilities
- Remove Worksheet Tabs, Rendering them Completely Invisible
- Disable Loading/Saving Other Workbooks BEFORE or AFTER App Is Loaded...
- Deactivate Print Operations, PDF and XPS Operations
- Completely Hide and Disable All Ribbons & Toolbars
- Remove Right-Click (context menu) and Double Click Options
- Disable 'Cell Copy and Cust To Clipboard" Commands
- Shut Off and Hide The Excel Formula Bar
- Only Allow Whichever Add-ins You Specify (Or None At All!)
- Load Customized Ribbon and Quick Access Toolbar Files To Your App Experience
- Design Custom Splash Screen or Logo At Startup for NNN Seconds (Free Design Resources too!)
- Hide Default 'Loading Workbook' Dialog Box in Excel
- Replace Excel Icon With Your Own Icon (Within Application AND In Windows Explorer)
- Set EXE Version Info and File Properties, such as FileVersion, LegalCopyright, Trademarks, ProductName, ProductVersion
- Expand To Other Languages With Editable Translation Files
- Create an End User License Agreement (EULA) that Must Be Accepted Prior To Use! (Samples Provided)
- Digitally Sign Your Application using Microsoft Authenticode Code Signing Certificate
- Free Online Resources and Training for Stock Images, Design Tools, Icons and More...
- Special Tips, Tricks and BONUS Macros To Interact With EXE and Windows Environment!
Skills covered in this course
Reviews
-
JJim Kesterson
Has already answered some of the questions I was hoping the course would cover.
-
GGarfield Stinvil
Honest Review - First and foremost, this course is a public service. The product is great but you won't ever get the most out of it if anything unless you have someone who a gracious enough to wade through all the boring technical jargon and present in an everyman common sense way. I am ashamed to say how much time I wasted trying to do it on my own. If you want to use this product, take this course. If you don't want to use it try learning it own your own. You'll fail. There is NOTHING on You Tube or anywhere else out here that is more practical and as thorough as this. The course can rub some people the wrong way because there are sections that could have been more polished or re-recorded. Certain sections seem like they could have been planned better but that is a minor quibble. The material is dense, and Danny explains it for us by doing all the hard work and in addition throws in bonus material. This knowledge will help you earn money and is so worth it.
-
llorenco marques
I decided to purchase this training before buying XLSPadlock. Dan give us the real in-depth nitty gritty. One thing that I found was not very clear - can I read (or import using Power Query) from files elsewhere on the network? Despite this 'oversight' - this course is still worth 5-stars
-
HHarsh Parasiya
It is the best instructor towards excel I have ever seen. I just love their excel course. I am your Fan Dan Sir