Unprotect Code Module in Code
Can you protect / unprotect a VBA code module in code? eg
ActiveWorkbook.VBProject.VBComponents("Module1").P roperties("Password") = "test" Thanks |
Unprotect Code Module in Code
You can't protect a single VBComponent. You can protect only the
entire project, and this cannot be done with VBA (unless you resort to the dreaded SendKeys). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Damien" wrote in message ... Can you protect / unprotect a VBA code module in code? eg ActiveWorkbook.VBProject.VBComponents("Module1").P roperties("Password") = "test" Thanks |
Unprotect Code Module in Code
OK Chip,
have you got any examples of doing that with SendKeys? I could try and work it out but if it's already been done ... "Chip Pearson" wrote: You can't protect a single VBComponent. You can protect only the entire project, and this cannot be done with VBA (unless you resort to the dreaded SendKeys). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Damien" wrote in message ... Can you protect / unprotect a VBA code module in code? eg ActiveWorkbook.VBProject.VBComponents("Module1").P roperties("Password") = "test" Thanks |
All times are GMT +1. The time now is 09:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com