Setting password for VBAProject through Macro

kool_mas

Board Regular
Joined
Oct 7, 2004
Messages
63
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.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,112,882
Messages
5,543,012
Members
410,583
Latest member
gazz57
Top