Protected Documents

[Guest]

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?

 

[Guest]

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

Mike

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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?

 

[Gord Dibben]

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