I try to include a pasword to open the workbook using xlspadlock.com 2024.2 but this option does not work at all. The options to generate in your program don’t appear. I test the option adding a sub to save de protected file as xlsm, when I open de final file extracted by the macro, It opens with out asking for the pasword.
Protect workbook using a password
- Thread starter jav2110
- Start date
Sure, as long as you don’t configure XLS Padlock to avoid that, it is permitted.
This is explained in our doc:
Why just compiling a workbook into EXE is not enough?
https://www.xlspadlock.com/doc/topics/improve-protection-of-your-workbooks.htm
In your specific case, try to enable this feature:
https://www.xlspadlock.com/doc/topics/prevent-common-vba-and-ole-hacks.htm
This is explained in our doc:
Why just compiling a workbook into EXE is not enough?
https://www.xlspadlock.com/doc/topics/improve-protection-of-your-workbooks.htm
In your specific case, try to enable this feature:
https://www.xlspadlock.com/doc/topics/prevent-common-vba-and-ole-hacks.htm
I configurated the option. I put a password in the Excel file and I put it in xlspadlock option. When testing the option with a macro, the extracted workbook do not have even the password of the Excel file. Is there any especial feature to activate this option correctly in xlspadlock? I only providen a psw in the blanket apace of your program.
Last edited:
Did you enable “Do not allow loading/saving other workbooks”.?
So, it’s what you asked: be unable to use a VBA hack to save the protected workbook somewhere else. If you still want to make a save, it’s also possible with VBA API: Allow saving non encrypted workbooks
Strange. Could you please take a screenshot of your XLS Padlock window? Maybe there is a glitch due to screen resolution.
Anyway, if I type a pasword in the application, I already tried the option with different settings mentioned and it doesn’t work. Could you try or give me the exact steps to use this functionality of the pasword. Because if I implement a macro to save the compiled file, the pasword disappears and it is very easy to open the extracted workbook.
Indeed, there is a sizing problem. We’ll have to fix that in the next update on that screen.
In which field did you type your password? In the first one or the second one?
Thus, the XLS Padlock’s option lets you prevent this. Moreover, it’s possible to disable access to the Visual Basic editor so your user won’t be able to type their macro.
I don’t understand why you don’t want to enable the XLS Padlock’s option that stops this. If you are worried about users saving your workbook themselves, just enable that option. With VBA SaveAs, it’s possible to save a workbook without password, even if the original workbook had one.
Thus, the XLS Padlock’s option lets you prevent this. Moreover, it’s possible to disable access to the Visual Basic editor so your user won’t be able to type their macro.
We will investigate this issue too.
Sizing issue has been normally fixed in XLS Padlock 2024.3:
XLS Padlock 2024.3 Released And Enhanced for Your Security Needs - December 9th, 2024 XLS Padlock
XLS Padlock version 2024.3 is now available on www.xlspadlock.com. This release focuses on improving compatibility, fixing critical bugs, and enhancing your user experience: Fixed Compatibility with Windows 11 24H2 and KB5046740 preview update: Resolved a critical issue affecting workbook functionality due to the latest Windows update preview. Improved User Interface: Several configuration pages have been updated to prepare for upcoming multi-language support and fix display glit…