Locking the VBA Project
Another possibility, some sort of error inside the project might be trying
to display itself to the user. No doubt you've locked the project for a
reason, but if you can, give it to the user with instructions how to unlock
the project. Once inside note if the code is stuck on a yellow line, or
and/or an error message displaying, or look at Tools / References for any
reference ticked and marked as "MISSING".
Regards,
Peter T
"John" wrote in message
...
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
|