View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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