Results 1 to 2 of 2
2008-05-16, 05:15 #1
- Join Date
- Oct 2005
- Thanked 1 Time in 1 Post
Protecting a workbook (Excel 2003)
What is the difference b/w protecting a workbook for 'structure' and protecting it for 'windows'..??..??
2008-05-16, 08:12 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
Re: Protecting a workbook (Excel 2003)
From the Excel help file:
To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed and new worksheets can't be inserted, select the Structure check box.
To use windows of the same size and position each time the workbook is opened, select the Windows check box.
These protection mechanisms apply to the entire workbook, whereas the 'Objects' and 'Scenarios' protections apply to viewing and editing of an individual worksheet. Again, from the Excel help file:
To prevent changes to graphic objects on worksheets or charts, select the Objects check box.
To prevent changes to the definitions of scenarios on a worksheet, select the Scenarios check box.Cheers,
[MS MVP - Word]