set password

[vijay2482]

how to set password for VBAProject?
i know to protect the spreadsheet
i want to password protect my coding in the VBA Project module

 

[Peter_SSs]

how to set password for VBAProject?
i know to protect the spreadsheet
i want to password protect my coding in the VBA Project module

Like this?

Tools|VBAProject properties...|Protection tab|complete password section|OK

 

[jim may]

Alt+F11
Tools.
VBAProject Properties...
Protection Tab

If prior to V2007

 

[Colin Legg]

Hi,

In the Visual Basic Editor, in the Project Explorer window select the project you want to protect.

Then go Tools | VBA Project properties | Protection tab.
Tick the "Lock project for viewing" checkbox and enter in and confirm the password. Save the project.

Once it has been closed and re-opened the protection will come into effect.

HTH

 

[vijay2482]

thanks to all who responded so quickly