set vba properties (password)

[dhartikumar]

I am new in this forum. I am working as a Sr. Manager - Database in IDBI capital.


i want to set vba properties (password). for my vba code. ( any codes for that). or how to set when file open.


Dhartikumar

 

[Hui]

Right click on your Project in VBA and select VBA Project Properties

Select the Protection Tab

Set passwords

 

[dhartikumar]

when i open the excel file , it will set automatical vba password.,

is it possible?

 

[Hui]

By default VBA doesnt have any passwords set

You can write a subroutine to run every time Excel starts and set a password if thats what you mean