Excel’s Built-In Security Tools, Boost Features, Lock Down & Create Windows Applications EXE
#Excels #BuiltIn #Security #Tools #Boost #Features #Lock #Create #Windows #Applications #EXE
رابط تحميل الفيديو كامل HD .. <اضغط هنا>
كيف Excel’s Built-In Security Tools, Boost Features, Lock Down & Create Windows Applications EXE
Excel To EXE, Make Secure Windows Applications From Excel
Go Beyond Excel’s Built-In Security Tools, Boost Features, Lock Down & Create Windows Applications (EXE) with XLSPadlock
———-
📥 Download Practice Material from: bit.ly/47x7fXa
———
VIDEO TIMESTAMPS ⏱👉
================
00:00:00 Intro and Basic Protection Is Easy to Hack – Demonstration
00:04:43 DEMO – Formula Protection and Secure App Features
00:11:18 Installing XLSPadlock
00:17:15 Formula Protection and How It Works
00:20:54 Workbook To Secure App Basics and Recalculate Advance Option
00:25:40 Converting VBA To Binary with the VBA Compiler
00:34:39 Licensing Features Overview
00:46:33 Activation Protection vs No Activation
00:53:54 Key Generation with XLSPadlock
00:59:55 Resetting Activation on a PC for Testing Purposes
01:01:42 Hardware-Locked Activation Keys
01:07:36 Dongle or USB Protection
01:17:46 Activation Key Restriction Options
01:24:31 More Options with Included ‘Stand-Alone’ Key Generator
01:31:43 Additional Activation Options
01:34:11 Allowing Secure Save or Not…
01:41:04 Disable LoadingSaving Other Workbooks (and how to Temp re-enable)
01:45:34 Extended Save Options
01:51:08 Decrypting a Secure Save File
01:56:23 Use a Custom Secure Save File Extension!
01:59:20 Control Excel Version(s) Allowed
02:01:17 Build EXE for 32-bit, 64-bit or Universal
02:02:32 Accessing EXEPath and Using Hyperlink To Open File
02:06:54 Accessing EXEPath and Using Shell To Open Files in VBA
02:15:21 Companion Files in VBA – Open Hidden Workbook
02:26:35 Using SetOption Helper To Open Workbooks Despite Security Settings
02:35:23 Save and Load Options Overview
02:40:03 Restriction Options
02:46:40 VBA Security
02:52:16 Formulas and Passwords
02:55:34 Excel Add-ins
02:58:11 Excel Custom UI
03:00:13 Basic Splash Screen and Settings
03:02:33 Make Your Own Better Splash Screen and Resources
03:09:43 Custom Icon for Your App and How to Make One
03:14:10 Free Online Icons for Your App
03:15:31 Customize EXE Version Info
03:18:08 Display Product or File Version in WorksheetFunction and VBA
03:21:30 Display Product or File Version in Userform Caption Dynamically
03:26:34 Custom Localization and Language Files
03:28:03 End User License Agreements or Terms
03:32:32 Code Signing
03:42:02 Function To Detect If Protection is Enabled
03:46:54 Completely Hide Sheet Tabs and Set Up Navigation Buttons
03:56:36 Detect TrialMode and Number of Uses or Days Remaining
04:08:16 Removing Row and Column Headings and Cell Gridlines
04:10:24 Real Life Consulting Protection DEMO 01 – Settings Dan Uses
04:18:37 Real Life Consulting Protection DEMO 02 – Dropbox Stuff & Compiling a Nice Email
04:22:03 Creating An Installer File with Paquet Builder
04:27:48 Asking Questions Here and GDGSoft Forum
———-
Who this course is for:
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.
———–
#excel #exceltutorial #exceltips
#Excels #BuiltIn #Security #Tools #Boost #Features #Lock #Create #Windows #Applications #EXE