Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting Workbooks in Excel 2003
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |