How do I password protect a workbook in Excel?
 

I used to do my personal budgets in Excel 2003 and I password protected them.
Every time I accessed the workbook I had to write the password. Now I have
the 2007 version of Excel and I don't know how to password protect my
workbooks in Excel 2007. How can I do this?

How do I password protect a workbook in Excel?
 

From help

To allow only authorized reviewers to view or modify your content, you can
help secure your entire document with a password.

1.. Click the Microsoft Office Button , and then click Save As.
2.. Click Tools, and then click General Options.
a..
1.. Do one or both of the following:
2.. If you want reviewers to enter a password before they can view the
document, type a password in the Password to open box.
a.. If you want reviewers to enter a password before they can save changes
to the document, type a password in the Password to modify box.
1.. Notes
2.. Password to open By default, this feature uses advanced encryption.
Encryption is a standard method used to help make your file more secure.
a.. Password to modify This feature does not use any encryption method.
It is designed so you can collaborate with content reviewers you trust. Is
not designed to help make your file more secure.
b.. Both passwords You can assign both passwords - one to access the
file and one to provide specific reviewers with permission to modify its
content. Make sure each password is different from the other.

1.. Important
2.. 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. Passwords should be 8 or more
characters in length. A pass phrase that uses 14 or more characters is
better. For more information, see Help protect your personal information
with strong passwords.
3.. It is critical that you remember your password. If you forget your
password, Microsoft cannot retrieve it. Store the passwords that you write
down in a secure place away from the information that they help protect.
4..
5.. If you don't want content reviewers to accidentally modify the file,
select the Read-only recommended check box. When opening the file, reviewers
are asked whether or not they want to open the file as read-only.
6.. Click OK.
7.. When prompted, retype your passwords to confirm them, and then click
OK.
8.. Click Save.
9.. If prompted, click Yes to replace the existing document

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Elmer" wrote in message
...
I used to do my personal budgets in Excel 2003 and I password protected
them.
Every time I accessed the workbook I had to write the password. Now I have
the 2007 version of Excel and I don't know how to password protect my
workbooks in Excel 2007. How can I do this?

How do I password protect a workbook in Excel?
 

Thank you, very helpful and answered my question.

"Bob Phillips" wrote:

From help

To allow only authorized reviewers to view or modify your content, you can
help secure your entire document with a password.

1.. Click the Microsoft Office Button , and then click Save As.
2.. Click Tools, and then click General Options.
a..
1.. Do one or both of the following:
2.. If you want reviewers to enter a password before they can view the
document, type a password in the Password to open box.
a.. If you want reviewers to enter a password before they can save changes
to the document, type a password in the Password to modify box.
1.. Notes
2.. Password to open By default, this feature uses advanced encryption.
Encryption is a standard method used to help make your file more secure.
a.. Password to modify This feature does not use any encryption method.
It is designed so you can collaborate with content reviewers you trust. Is
not designed to help make your file more secure.
b.. Both passwords You can assign both passwords - one to access the
file and one to provide specific reviewers with permission to modify its
content. Make sure each password is different from the other.

1.. Important
2.. 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. Passwords should be 8 or more
characters in length. A pass phrase that uses 14 or more characters is
better. For more information, see Help protect your personal information
with strong passwords.
3.. It is critical that you remember your password. If you forget your
password, Microsoft cannot retrieve it. Store the passwords that you write
down in a secure place away from the information that they help protect.
4..
5.. If you don't want content reviewers to accidentally modify the file,
select the Read-only recommended check box. When opening the file, reviewers
are asked whether or not they want to open the file as read-only.
6.. Click OK.
7.. When prompted, retype your passwords to confirm them, and then click
OK.
8.. Click Save.
9.. If prompted, click Yes to replace the existing document

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Elmer" wrote in message
...
I used to do my personal budgets in Excel 2003 and I password protected
them.
Every time I accessed the workbook I had to write the password. Now I have
the 2007 version of Excel and I don't know how to password protect my
workbooks in Excel 2007. How can I do this?

How do I password protect a workbook in Excel?
 

I have tried this several times and each time I get the following error:

{Microsoft Office Excel cannot access the file 'C:\Documents and
Settings\Bob\My Documents\(some random 8 character string. In this case it
was 993c7100.)' There are several possible reasons:

The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open
workbook.}

Now, this is in the Office 2007 Student version. I did attempt to password
protect the file as an Excel 97-2003 version and had no problem protecting it
but I keep geting a nag dialog box saying that I could improve the protecting
by converting it to Excel 2007. When I do this, I get the above dialog box. I
did try using a different file name and got the same error. After several
tries, I had many of these 8 character files stored in my folder. I did
change the Sharing of the Hardrive I was saving to from Shared to unshared
but it made no difference. I also closed and then restarted Excel with the
drive unshared and same thing.

I really need the ability to protect my files. I think I should be able to
do this. It does work for 2003 .xls files but I do not want the nag dialog
box to come up each time.

Thanks for your time,

Robert Hanrahan

"Bob Phillips" wrote:

From help

To allow only authorized reviewers to view or modify your content, you can
help secure your entire document with a password.

1.. Click the Microsoft Office Button , and then click Save As.
2.. Click Tools, and then click General Options.
a..
1.. Do one or both of the following:
2.. If you want reviewers to enter a password before they can view the
document, type a password in the Password to open box.
a.. If you want reviewers to enter a password before they can save changes
to the document, type a password in the Password to modify box.
1.. Notes
2.. Password to open By default, this feature uses advanced encryption.
Encryption is a standard method used to help make your file more secure.
a.. Password to modify This feature does not use any encryption method.
It is designed so you can collaborate with content reviewers you trust. Is
not designed to help make your file more secure.
b.. Both passwords You can assign both passwords - one to access the
file and one to provide specific reviewers with permission to modify its
content. Make sure each password is different from the other.

1.. Important
2.. 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. Passwords should be 8 or more
characters in length. A pass phrase that uses 14 or more characters is
better. For more information, see Help protect your personal information
with strong passwords.
3.. It is critical that you remember your password. If you forget your
password, Microsoft cannot retrieve it. Store the passwords that you write
down in a secure place away from the information that they help protect.
4..
5.. If you don't want content reviewers to accidentally modify the file,
select the Read-only recommended check box. When opening the file, reviewers
are asked whether or not they want to open the file as read-only.
6.. Click OK.
7.. When prompted, retype your passwords to confirm them, and then click
OK.
8.. Click Save.
9.. If prompted, click Yes to replace the existing document

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Elmer" wrote in message
...
I used to do my personal budgets in Excel 2003 and I password protected
them.
Every time I accessed the workbook I had to write the password. Now I have
the 2007 version of Excel and I don't know how to password protect my
workbooks in Excel 2007. How can I do this?

How do I password protect a workbook in Excel?
 

Try opening the Office Button on the top left of the Excel application.
Choose Prepare, and then Encrypt document. This forces the person to enter a
password to open and view the document.
--
Chris
MCP, MCSA


"I still have trouble with passwords" wrote:

I have tried this several times and each time I get the following error:

{Microsoft Office Excel cannot access the file 'C:\Documents and
Settings\Bob\My Documents\(some random 8 character string. In this case it
was 993c7100.)' There are several possible reasons:

The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open
workbook.}

Now, this is in the Office 2007 Student version. I did attempt to password
protect the file as an Excel 97-2003 version and had no problem protecting it
but I keep geting a nag dialog box saying that I could improve the protecting
by converting it to Excel 2007. When I do this, I get the above dialog box. I
did try using a different file name and got the same error. After several
tries, I had many of these 8 character files stored in my folder. I did
change the Sharing of the Hardrive I was saving to from Shared to unshared
but it made no difference. I also closed and then restarted Excel with the
drive unshared and same thing.

I really need the ability to protect my files. I think I should be able to
do this. It does work for 2003 .xls files but I do not want the nag dialog
box to come up each time.

Thanks for your time,

Robert Hanrahan

"Bob Phillips" wrote:

From help

To allow only authorized reviewers to view or modify your content, you can
help secure your entire document with a password.

1.. Click the Microsoft Office Button , and then click Save As.
2.. Click Tools, and then click General Options.
a..
1.. Do one or both of the following:
2.. If you want reviewers to enter a password before they can view the
document, type a password in the Password to open box.
a.. If you want reviewers to enter a password before they can save changes
to the document, type a password in the Password to modify box.
1.. Notes
2.. Password to open By default, this feature uses advanced encryption.
Encryption is a standard method used to help make your file more secure.
a.. Password to modify This feature does not use any encryption method.
It is designed so you can collaborate with content reviewers you trust. Is
not designed to help make your file more secure.
b.. Both passwords You can assign both passwords - one to access the
file and one to provide specific reviewers with permission to modify its
content. Make sure each password is different from the other.

1.. Important
2.. 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. Passwords should be 8 or more
characters in length. A pass phrase that uses 14 or more characters is
better. For more information, see Help protect your personal information
with strong passwords.
3.. It is critical that you remember your password. If you forget your
password, Microsoft cannot retrieve it. Store the passwords that you write
down in a secure place away from the information that they help protect.
4..
5.. If you don't want content reviewers to accidentally modify the file,
select the Read-only recommended check box. When opening the file, reviewers
are asked whether or not they want to open the file as read-only.
6.. Click OK.
7.. When prompted, retype your passwords to confirm them, and then click
OK.
8.. Click Save.
9.. If prompted, click Yes to replace the existing document

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Elmer" wrote in message
...
I used to do my personal budgets in Excel 2003 and I password protected
them.
Every time I accessed the workbook I had to write the password. Now I have
the 2007 version of Excel and I don't know how to password protect my
workbooks in Excel 2007. How can I do this?