Hi Again
I opened a new workbook and recorded a simple select range, erase.
this one is not asking for the password.
The other two have userform in them.????
Any ideas
Regards
John
"Andy Smith" wrote in message
...
You must have self-modifying code! The only way it wouold ask for the
project password is if code gets changed.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"John" wrote:

Hi Everyone
In the Project menu, I selected my project, right click "VBA Project
Properties". The Tab -Protection, I check mark "Lock Project for Viewing"
with password. That works fine.
Problem:
If someone use any macro in that workbook, then before closing the workbook
it
request a Password and you can't cancel that menu.
I don't get it, maybe I'm at the wrong place to protect my project from view.
Can enyone enlighten me.

Regards
John



.