sorry about the confusion,

she would like to use the protect the workbook option.

she selects protect workbook, selects structure, enters a password. then
when she sends the document to someone else they can make changes to it.

maybe i dont understand how this work?
--
Thanx for any help
Ray


"Gord Dibben" wrote:

Your terms are confusing.

You use the words "protect worksheet" and "protect the whole document"

These are two different and separate operations performed in different dialog
windows.

Excel has three protection methods.

Protect the sheet means just one sheet is protected from changes.

Protect the document means prevent anyone from opening the workbook.

Protect the workbook means protect from adding sheets or changing window sizes
and other stuff.

Which does she want to employ?


Gord Dibben MS Excel MVP

On Fri, 9 Feb 2007 09:29:00 -0800, ray wrote:

thank you, but she is trying to protect the whole document.
--
Thanx for any help
Ray


"Mike" wrote:

When you protect make sure the only check marks are against 'select locked
cells' - 'select unlocked cells.

Mike

"ray" wrote:

hi there,
i am with a client and she is trying to protect an Excel worksheet. She
creates the document, clicks on protect worksheet, enters the password. if
you go back you have the option to unprotect the document. But when you open
the document anyone can make changes to it without the password.

any ideas?
--
Thanx for any help
Ray