set password to VBA code in .xlsx file

Hi all,

I have the following situation:
I've built a file for other users without macros (or other VBA) and saved as .xlsx
Now I want to protect it from users writing VBA code (to get to the protected cells of the file).
Of course they would have to save the file as .xlsm to be able to use the VBA, but I'd like to prevent them from even getting to the VBA project viewer.

I know I can do this in a .xlsm file with a password, but it doesn't seem to work for my .xlsx file. When I set a password, close the file and open it again, you can get to the (empty) code without Excel asking for the password. Is this because it is not a .xlsm file?

To be honest, you're wasting your time. If someone can write VBA code to access your protected workbook/worksheets, they can write it, and save it, in a separate .xlsm file. The code in this workbook can refer to the workbook and worksheets and, without much effort, remove any protection you have put in place.

your file will probably be relatively safe from a typical user but, for a user with VBA skills, it will never be secure.

Sorry to be the bearer of bad news but you may as well save yourself some time.

If it needs to be secure, you would be better off investing in a third party product like Spreadsheet Sentry.

Regards, TMS

O haha didn't even think of that

Then I'll just live with it, no big deal.

Thanks for the help!

You're welcome. Thanks for the rep.