To allow only authorized users to view or modify your data, you can help
secure your entire workbook file with a password (password: A way to restrict
access to a workbook, worksheet, or part of a worksheet. Excel passwords can
be up to 255 letters, numbers, spaces, and symbols. You must type uppercase
and lowercase letters correctly when you set and enter passwords.).

On the File menu, click Save As.
On the Tools menu, click General Options.
Do either or both of the following:
If you want users to enter a password (password: A way to restrict access to
a workbook, worksheet, or part of a worksheet. Excel passwords can be up to
255 letters, numbers, spaces, and symbols. You must type uppercase and
lowercase letters correctly when you set and enter passwords.) before they
can view the workbook, type a password in the Password to open box, and then
click OK.
If you want users to enter a password before they can save changes to the
workbook, type a password in the Password to modify box.
Note Unlike passwords you specify in the Password to open box, passwords
you specify in the Password to modify box are not encrypted. These passwords
are only meant to give specific users permission to modify workbook data. For
optimal password security, it's best to assign both passwords. An encrypted
password to access the workbook, and one to provide specific users with
permission to modify its content.

Important Use strong passwords that combine uppercase and lowercase
letters, numbers, and symbols. Weak passwords don't mix these elements.
Strong password: Y6dh!et5. Weak password: House27. Use a strong password that
you can remember so that you don't have to write it down.

If you want to use a different encryption type, click Advanced, click the
type you want in the Choose an encryption type list, and then click OK.
If needed, specify the number of characters you want in the Choose a key
length box.
Note Document property encryption is enabled by default for most
encryption types and providers. It prevents unauthorized users from viewing
summary and custom file properties (such as the author or any custom file
information) in the Properties dialog box. When users right-click the
password-protected file, and then click Properties, information won't be
available on the Summary tab and Custom tab. Authorized users, however, can
open the file and view all file properties (File menu, Properties command).
To disable document property encryption, clear the Encrypt document
properties check box.

Click OK.
When prompted, retype your passwords to confirm them.
Click Save.
If prompted, click Yes to replace the existing workbook.
Note You can also secure a workbook with a password on the Security tab
of the Options dialog box (Tools menu, Options command).


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"tdw" wrote:

How do I make a workbook read only for everyone except myselg???