the VBA has a separate password. Open the IDE (ALT+F11) then look under
Tools / VBA Project Properties
In the form, switch to the Protection tab - you'll see there that it may be
password protected



"AlForester" wrote in message
...
I have a spreadsheet that does not have a password for the file, but the
code
is locked for viewing with a password.

Does anybody know what would cause the password prompt to be displayed
when
the file is closed? This will happen either when the user clicks the X or
when a button code runs to close the file and leave excel open or close
excel
with application.quit. If the code leaves excel open, the password prompt
appears when the user finally closes excel.

Any thoughts would be greatly appreciated.
--
WEW