VBA Project Password Stripped when saving as .xlsx

I have an excel file that is distributed within my organization. That file contains certain worksheets that the end-users do not need to see or make changes to, so in the VBA project, I change those files to "VeryHidden". Then I protect the workbook's VBA code by going to Tools->VBAProject- Project Properties-> Protection tab and adding a password. This worked great as it allowed all the other sheets to function as intended, but didn't allow the users to access the sheets that were hidden.

However, we recently upgraded to Excel 2007, and the password protection is stripped whenever the file is saved with the extension .xlsx. I can save it as a "macro-enabled" file with the extension .xlsm, but all that needs to be done to remove the password is to save it with the .xlsx extension again. Is there something that can be done in Excel 2007 to protect VBA code, or am I doing something completely wrong?

This is my first post here, so please let me know if I've done something wrong!

Hi

If the workbook is saved as an .xlsx file it would (or should!) also remove the VBA code (ie all VBA modules would be removed from the file). Is this not what you are observing?

Richard

There is nothing you can do about that as far as I know, unfortunately. (it's not particularly secure anyway)

You could use code in the Workbook_BeforeSave event to prevent the user from doing a SaveAs.

Then you would also need to force users to enable macros, a topic covered extensively in the forum.

Just protecting the VBA project will not prevent unhiding sheets. A few simple lines of code from another workbook could unhide the sheets

Protecting the workbook would add a level of difficulty.

If you intercept the SaveAsUI, you can cancel that and replace it with a GetSaveAsFilename dialog and prevent the user from changing the extension.