ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2007 version of Excel (https://www.excelbanter.com/excel-discussion-misc-queries/251819-2007-version-excel.html)

Nikki

2007 version of Excel
 
How do I create a password so that the password is required upon opening the
workbook?

trip_to_tokyo[_3_]

2007 version of Excel
 
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.



"Nikki" wrote:

How do I create a password so that the password is required upon opening the
workbook?



All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com