How to use vba code to save .xlsc file?

XLS Padlock
1

If you enable “Do not prompt user for filename when saving”, then your XLS Padlock compiled workbook won’t create saves itself.

You are then responsible for using VBA to save your workbook as a file and encrypt it if you want. Otherwise, changes will be lost. So it is not recommended to use it, unless you know what you are doing.

What are the code to do the task?

Thank you.

Frank Chan

2

In the incoming XLS Padlock 2, there is a new VBA extension that allows VBA developers to save encrypted workbooks directly without user prompt.

3

That is great!
Looking forward to it!!
Thank you.

4

When will version 2 be available? This is an important feature to have

5

XLS Padlock 2 has been released. See the user guide for the VBA code.