If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Setting password for VBAProject through Macro

Thread starter kool_mas
Start date Oct 4, 2006

kool_mas

Board Regular

Oct 4, 2006

How can I set the password of VBAProject in the VB editor and lock the project for viewing?

From the control excel file I am opening another excel file which has some sheets I dont want the end user to be able to see.

Code:

strXlsFile = strOutputDir & strOrgVar & ".xls"
    
Set wbOrg = Workbooks.Open(strTemplateXls_CT)

Application.DisplayAlerts = False 'Always overwrites if existing file exists

Application.Calculation = xlCalculationAutomatic 

' Here I want to have the code to set the password to the vba project . I already have the code to make only 1 output sheet visible and all others very hidden.

wbOrg.SaveAs (strXlsFile)
    
       
wbOrg.Close

Appreciate any help in this.