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.

's Computer Specifications

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.

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: which is right, protect password:="xyz" or protect password = "xyz	Ryan H	Microsoft Excel Programming	0	13th Jan 2010 08:22 PM
Want to password protect one mdb but still access it from another mdb.	jamesburkett@gmail.com	Microsoft Access Security	1	14th Jun 2006 07:09 PM
Password protect content editing vs. password protect open document ??	Camille Petersen	Microsoft Word Document Management	1	3rd May 2006 01:25 PM
Password protect content editing vs. password protect open document ??	Camille Petersen	Microsoft Word New Users	1	3rd May 2006 01:25 PM
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	Microsoft Excel Discussion	1	24th Jun 2005 01:20 AM