how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[Daniel]

how do i password protect an .xls file? how do i unlock it for automation.
e.g. want to unlock and access a .xls from another .xls macro.

[sanskar_d]

Hi Daniel,

Go to "Save as" option from file menu.

In the "Tools Menu" Select general options and insert the desired password.


Regards,

Sam.