I would like to protect the VBA code in an Excel 2003 workbook. When I set the VBAProject Properties, Lock Project (yes), and enter passwords, I can save the file.

When I reopen the file, it is protected but I cannot save the file again. I receive an error message:

"You cannot save to the file format when the VBA project is protected. You may unprotect the VBA project by choosing the Properties command on the Visual Basic Editor's Tools menu, and entering the password for the active project."

When I follow the instructions to "unprotect" the file, it still will not save ("Document Not Saved"), nor can I perform a "File Save As" under a new name. The file is not a read-only file.

My goal is to protect the VBA code from the user, but allow the user to save a copy of the file when they make changes to the spreadsheets.

Am I doing something wrong?

Thanks in advance for the help.

Susan