VBA API and Advanced Features
EXE Command-Line Switches
Last Updated: October 30, 2025Your compiled application’s EXE file supports several command-line switches (also known as arguments) that automate specific actions at startup. You can use these in shortcuts...
VBA API Cookbook & Recipes for XLS Padlock
Last Updated: October 30, 2025This topic provides a comprehensive collection of VBA code snippets (“recipes”) for advanced control over your protected application at runtime. Using the XLS Padlock VBA...
Get Path to a File in the EXE’s Folder with VBA
Last Updated: October 20, 2025This VBA function retrieves the full path to a file located in the same directory as your application’s EXE. It is particularly useful for accessing...
Programmatically Save & Restore Custom Values with VBA
Last Updated: October 30, 2025When using the Save defined cell values only mode, XLS Padlock allows you to save and restore custom values in addition to pre-defined cell values....
Customizing the Excel User Interface
Last Updated: October 20, 2025As explained in Microsoft’s documentation, you can customize the Excel user interface by placing a specially crafted .officeUI file in a specific user folder. XLS...
Access Secure Files from a New Excel Instance
Last Updated: October 20, 2025Note This guide explains how to launch a new Excel instance from your protected workbook and grant it access to the secure workbook and its...
Using External References and Hyperlinks
Last Updated: October 20, 2025XLS Padlock protects one workbook per EXE file. If your workbook uses external references or requires additional files, you must update your paths to ensure...
