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?