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.

Description

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!

• This Excel course is for anyone who wants to learn Excel security secrets and create real Windows Applications (EXEs) directly from Excel files. No prior programming knowledge is needed.
• This course is probably not for you if you’re looking to learn unrelated Excel VBA code as that is covered in other courses, specifically on the topic of programming. We will, however, make sure you know how to use any code we provide inside and out and many tricks to make your Excel projects into professional, polished and secured Apps.
• If you're using Excel for Mac, you will have to virtualize Windows within Mac using programs like Parallels or Bootcamp, as XLSPadlock doesn't have a Mac version.

Course content

• Introduction
  • Intro and Basic Protection Is Easy to Hack - Demonstration
  • DEMO - Formula Protection and Secure App Features
• Protection With XLSPadlock - First The Basics
  • Installing XLSPadlock
  • Installing XLSPadlock - Info Document & Links
  • Formula Protection and How It Works
  • Workbook To Secure App Basics and Recalculate Advance Option
  • Converting VBA To Binary with the VBA Compiler
• Advanced Licensing Features
  • Licensing Features Overview
  • Activation Protection vs No Activation
  • Key Generation with XLSPadlock
  • Resetting Activation on a PC for Testing Purposes
  • Hardware-Locked Activation Keys
  • Dongle or USB Protection
  • Activation Key Restriction Options
  • More Options with Included 'Stand-Alone' Key Generator
  • Additional Activation Options
• Secure Save Files
  • Allowing Secure Save or Not...
  • Disable Loading/Saving Other Workbooks (and how to Temp re-enable)
  • Extended Save Options
  • Decrypting a Secure Save File
  • Use a Custom Secure Save File Extension!
• App Settings and File Management
  • Control Excel Version(s) Allowed
  • Build EXE for 32-bit, 64-bit or Universal
  • Accessing "EXEPath" and Using Hyperlink To Open File
  • Accessing EXEPath and Using Shell To Open Files in VBA
  • Companion Files in VBA - Open Hidden Workbook
  • Using SetOption Helper To Open Workbooks Despite Security Settings
• Advanced Security Settings
  • Save and Load Options Overview
  • Restriction Options
  • VBA Security
  • Formulas and Passwords
  • Excel Add-ins
  • OfficeIns Free Download Link
  • Excel Custom UI
• Customize EXE
  • Basic Splash Screen and Settings
  • Make Your Own Better Splash Screen and Resources
  • Custom Icon for Your App and How to Make One
  • Free Online Icons for Your App
  • Free Online Icons for Your App - Resources
  • Customize EXE Version Info
  • Display Product or File Version in WorksheetFunction and VBA
  • Display Product or File Version in Userform Caption Dynamically
  • Custom Localization and Language Files
  • End User License Agreements or Terms
  • Code Signing
• Special Tips, Tricks and Macros
  • Function To Detect If Protection is Enabled
  • Completely Hide Sheet Tabs and Set Up Navigation Buttons
  • Detect TrialMode and Number of Uses or Days Remaining
  • Removing Row and Column Headings and Cell Gridlines
  • Real Life Consulting Protection DEMO 01 - Settings Dan Uses
  • Real Life Consulting Protection DEMO 02 - Dropbox Stuff & Compiling a Nice Email
  • Creating An Installer File with Paquet Builder
  • Creating An Installer File with Paquet Builder - Info Document & Links
  • Asking Questions Here and GDGSoft Forum
  • Asking Questions Here and GDGSoft Forum - Info Documentation and Links
• BONUS
  • BONUS LECTURE