How to Unlock VBA project property through VBA

[MUKESHY12390]

Hi All,

I have built one macro , which adds the code (write/add event automatically) to new sheet.

code works fine up to mark. but since this particular stuff will be using by10-30 user so there is possibility someone can mess with code or not intentionally change the code.

I'm looking to protect the VBA project but if I protect, macro can't write code (add write/add event automatically) because of protection.

I would be wondering is there way to unlock the property first (through VBA code) and end of macro re-protect the property.


Any help would be much appreciated.



Regards,
Mukesh Y

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel-questions/59402-code-unprotect-vbaproject.html#post276912

 

[MUKESHY12390]

Thanks! I will take a look.

 

[MUKESHY12390]

thanks for your quick reply.

"Sendkey" is something I avoid using, I'm looking for other method let't see if I find out.

 

[MARK858]

Google the exact phase below then read the posts from the top (I won't paste a link because it is a different forum)...

Unprotect VBProject from VB code

 

[MUKESHY12390]

thanks, this is something I was looking for . let me play with this code.

will post here if everything works fine.

 

[Jaafar Tribak]

thanks, this is something I was looking for . let me play with this code.

will post here if everything works fine.

Probably the bigger issue is that you need to close and reopen the workbook after re-protecting the vbproject othetwise it won't take effect.