Locking project with workbook open?

  • Thread starter Thread starter Joe90
  • Start date Start date
J

Joe90

Is there a way to "re-lock" the project (VBAProject password) once unlocked?

I have some code that opens up the vba code to allow a reference to be
added, but to only advice so far is that you have to save and exit in order
to re-lock?

Joe
 
I assume you are using sendkeys. I haven't tried what you ask, but I don't
believe there is any requirement to save and exit before using sendkeys to
protect the project.
 
But you do have to close and reopen the workbook to hide the code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top