Locking the VBA Project
Hi Peter
I followed your instructions and nothing seems abnormal.
Thank you for your help.
Regards
John
"Peter T" <peter_t@discussions wrote in message
...
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
|