N Nikki Dec 24, 2009 #1 How do I create a password so that the password is required upon opening the workbook?
T trip_to_tokyo Dec 24, 2009 #2 Take the following action in EXCEL 2007:- 1. Launch EXCEL so that it has a new file in it. 2. Click on the Office Button (top left hand corer). 3. Prepare / Encrypt Document / enter the password that you want to use (for example test). - OK - enter the password again (test) - OK - Save the file in the normal way (Ctrl-S) 4. Close the file in the normal way (Office Button in top left hand corner / Close). 5. Now open the file once more. To get into it you will have to enter the password (test). If my comments have helped please hit Yes. Thanks.
Take the following action in EXCEL 2007:- 1. Launch EXCEL so that it has a new file in it. 2. Click on the Office Button (top left hand corer). 3. Prepare / Encrypt Document / enter the password that you want to use (for example test). - OK - enter the password again (test) - OK - Save the file in the normal way (Ctrl-S) 4. Close the file in the normal way (Office Button in top left hand corner / Close). 5. Now open the file once more. To get into it you will have to enter the password (test). If my comments have helped please hit Yes. Thanks.
