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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 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. (https://www.excelbanter.com/excel-worksheet-functions/32246-how-do-i-password-protect-xls-file-how-do-i-unlock-automation-e-g-want-unlock-access-xls-another-xls-macro.html)

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.

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.

--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=381805

All times are GMT +1. The time now is 05:19 PM.