by default, when you protect a workbook, the "Structure" of the workbook is
protected.
So, to easily test whether a workbook is already protected, try inserting
new worksheets or delete worksheets. If negative, the structure is protected.
Also, when a workbook is protected, cells in worksheets are still editable.
This is a main difference between workbook level and worksheet level
protection.
Regards,
Edwin Tam
http://www.vonixx.com
"Misha" wrote:
I cannot seem to protect a workbook in Excel 2003. I can protect Worksheets,
but not workbooks. Do I have to protect all the worksheets in a workbook
before protecting the workbook? Seems superfluous to me!!
I don't know what I am doing wrong. I click on Tool, Protection, Protect
workbook, but have not assigned a passwor. Even though I save the workbook,
it can still be modified.
Help please!!!
Thanks