Protected Documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ray - 08 Feb 2007 17:34 GMT

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?

Signature

Thanx for any help
Ray

Reply to this Message

Mike - 09 Feb 2007 09:30 GMT

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

Mike

> hi there,
> i am with a client and she is trying to protect an Excel worksheet. She
[quoted text clipped - 3 lines]
>
> any ideas?

Reply to this Message

ray - 09 Feb 2007 17:29 GMT

thank you, but she is trying to protect the whole document.

Signature

Thanx for any help
Ray

> When you protect make sure the only check marks are against 'select locked
> cells' - 'select unlocked cells.
[quoted text clipped - 8 lines]
> >
> > any ideas?

Reply to this Message

Gord Dibben - 09 Feb 2007 19:17 GMT

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

>thank you, but she is trying to protect the whole document.
>
[quoted text clipped - 10 lines]
>> >
>> > any ideas?

Reply to this Message

ray - 09 Feb 2007 21:15 GMT

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?

Signature

Thanx for any help
Ray

> Your terms are confusing.
>
[quoted text clipped - 30 lines]
> >> >
> >> > any ideas?

Reply to this Message

Gord Dibben - 09 Feb 2007 22:40 GMT

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
Tools>Protection>Protect Sheet.

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

Gord

>sorry about the confusion,
>
[quoted text clipped - 4 lines]
>
>maybe i dont understand how this work?

Reply to this Message