Protect current VBA Project?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, All

Is it possible to protect current VBA Project with a password in VBA?

There is a Protection Property of VBProject Object in "Microsoft Visual
Basic for Application Extensibility", but where i could set the password?
 
Right click the VBA project in the project view.
Select VBA Project properties.
Click the Protection tab.
Check lock for viewing and then provide password.

the next time you open the project you will be prompted to supply the
passowrd.
 
The only way to assign a password with code is by using Sendkeys. I've
never done it but others have reported that it works.

--
Jim
| Hi, All
|
| Is it possible to protect current VBA Project with a password in VBA?
|
| There is a Protection Property of VBProject Object in "Microsoft Visual
| Basic for Application Extensibility", but where i could set the password?
 
Jim Rech you mentioned that
(but others have reported that it works)

Colud you please let me know when you get it ?
i.e. Is it possible to protect current VBA Project with a password i
VBA
 

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

Similar Threads

VBA code syntax to protect/unprotect VBProject asumming if Password is known. 3
Excel VBA Project Has Protection? 2
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
Knowing is a workbook's VBA project has password or not 2
Setting up Solver reference in a protected VBA project 1
Cannot view code in VBE of a file with no password protection 3
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Locking the VBA Project 13

Back
Top