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

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

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

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

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

Protecting the workbook does not disallow making changes to the sheets other
than disallowing sheet deletion or window re-sizing and structural changes.

To disallow changing values in cells, formatting, inserting rows and columns,
sorting, filtering and other stuff she must protect the worksheet.

Is that what she means? Each sheet gets protected one at a time under
ToolsProtectionProtect Sheet.

You cannot protect multiple sheets at once without using VBA code.


Gord

On Fri, 9 Feb 2007 13:15:01 -0800, ray wrote:

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?