Programmatically unlock Project

[rex759]

Hello,

I’m using the code below to copy a module to a new workbook. The only issue I’m having is I want to lock the project from viewing. If the project is locked, the module doesn’t get copied over. Is there a way to unlock the project, run the macro and relock it?

'Copy the "HIDE" macro to new workbook
Const MODULE_NAME    As String = "hide"         ' Name of the module to transfer
Const TEMPFILE2       As String = "c:\Modul.bas" ' temp textfile
  
   '** export the module to a textfile
  Workbooks(mydatafile).VBProject.VBComponents(MODULE_NAME).Export TEMPFILE2
   'import the module to the new workbook
  Workbooks(TEMPFILE).VBProject.VBComponents.Import TEMPFILE2
   'kill the textfile
   Kill TEMPFILE2

 

[Mike Blackman]

Hi,

The point of the Project Protection is to protect the project, I don't believe you can do this with code. Would have to be a manual step i'm afraid.

 

[JamesW]

As Mike said, it will need to be done manually. Have a look here:

http://www.ozgrid.com/VBA/protect-vba-code.htm

Also, another Basingstokeian?! Another person to join us for drinks in April!?

 

[MrKowz]

It can be done programmatically using the SendKeys methods.

Check out this post, taking special note to post#7:

http://www.mrexcel.com/forum/showthread.php?t=59402

 

[Mike Blackman]

Who's going and when?

 

[Mike Blackman]

Is this not against board rules anyhow to post replies that breach protection?

 

[JamesW]

Good pint Mike. I read this as "I want to lock the project".

Rex: http://www.mrexcel.com/forum/showthread.php?t=127080 section 20.

 

[MrKowz]

Is this not against board rules anyhow to post replies that breach protection?

It is against board rules to ask questions and post replies on cracking and/or bypassing passwords and protection. My understanding is that the OP is trying to make his own workbook actually more secure by locking/unlocking the VBAProject programmatically.

Also, the link I provided requires that the user know the password anyway.

 

[rex759]

You are correct MrKowz. It's my code and workbook. It's going to be used by others and I wnated to protect the project from being tampared with.

Thank you