How to protect an Excel workbook

 

 

 

 Check the following video tutorials about XLS Padlock made by an Excel expert:
https://excelvbaisfun.com/lessons/installing-xlspadlock/

 

 

 

1. Open the workbook you want to protect, and save changes.

2. Configure general and security options in XLS Padlock.

Choose Compile to Exe in the XLS Padlock menu or ribbon:

Before Excel 2007: “XLS Padlock” menu

Starting from Excel 2007: “XLS Padlock” ribbon

 

 

Make sure you have saved your Excel document before starting XLS Padlock.

 

 

3. Build your application

After configuring your application’s settings, you can build your secure application with the following button or by pressing F5: the resulting application EXE file is created.

After compilation, the following message is shown:

You can start the application, view compilation log (especially useful if some error occurred), open the destination folder…

 

When you run the compiled workbook, if you see strange results or a malformated workbook, try to turn the following option on: “Use Excel automation for formula protection” available in Formulas and Passwords page.

 

 

How to distribute a protected workbook

 


Copyright © 2021 G.D.G. Software