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.

[bigwheel]

"Daniel" wrote:

> 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.
>

Do you want file protection or just workbook or worksheet protection?