Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    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'..??..??

  2. #2
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 464 Times in 382 Posts

    Re: Protecting a workbook (Excel 2003)

    Hi DJM,

    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.

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts