LAF,

Locking the projects hides the VBA code. If you don't want people to be
able to open the workbook at all, you need to assign a Password to Open or
Password to Modify, as needed, in the Tools dropdown of the Save-As dialog.
This is for Excel 2002; you don't say which version you're using.

Earl Kiosterud
www.smokeylake.com

"LAF" wrote in message
...

I have a project that I am trying to lock with a password to prevent our
users from changing it and seeing the code. I have gone into the Visual
Basic code. I then selected Tools - VBA Project Properties. Then I
went into the Protection tab and checked the box in Lock Project and
entered a password. I then saved my file. When I open it up again and
make a change on any of the sheets, it allows me to save the file even
without putting in the password. I thought with the password set, you
wouldn't be able to make changes and save it? Is there a way to
prevent this because we don't want any of our users disabling the
macros and then making changes to the sheets?


--
LAF
------------------------------------------------------------------------
LAF's Profile:
http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=482271