Protect Workbook vs Worksheet??

Hi,

I'm using Excel 2003. I need to know what the purpose of Protect Workbook
is under Tools | Protection. It gives 2 options, protect workbook for
Structure and Windows.

I understand the options and functionality under Protect Worksheet, and I
thought that the Protect Workbook option would do the same for the whole
workbook instead of individual worksheets.

When trying this out, I protected a workbook, saved it, but was still able
to edit it and resave without having to put in a password or even unprotect
it.

So, what does Protect Workbook do and what are the Structure and Windows
options for.

Thanks,

Dan

from help
Password protect a worksheet or workbook
Protect worksheet elements

Protect worksheet elements from all users

1.. Switch to the worksheet you want to protect.

2.. Unlock any cells you want users to be able to change: select each cell
or range, click Cells on the Format menu, click the Protection tab, and then
clear the Locked check box.

3.. Hide any formulas that you don't want to be visible: select the cells
with the formulas, click Cells on the Format menu, click the Protection tab,
and then select the Hidden check box.

4.. Unlock any graphic objects you want users to be able to change.

How?

You don't need to unlock buttons or controls for users to be able to click
and use them. You can unlock embedded charts, text boxes, and other objects
created with the drawing tools that you want users to be able to modify. To
see which elements on a worksheet are graphic objects, click Go To on the
Edit menu, click Special, and then click Objects.

1.. Hold down CTRL and click each object that you want to unlock.
2.. On the Format menu, click the command for the object you selected:
AutoShape, Object, Text Box, Picture, Control, or WordArt.
3.. Click the Protection tab.
4.. Clear the Locked check box, and if present, clear the Lock text
check box.
5.. On the Tools menu, point to Protection, and then click Protect Sheet.

6.. Type a password for the sheet.

Note The password is optional; however, if you don't supply a password,
any user will be able to unprotect the sheet and change the protected
elements. Make sure you choose a password you can remember, because if you
lose the password, you cannot gain access to the protected elements on the
worksheet.

7.. In the Allow all users of this worksheet to list, select the elements
that you want users to be able to change.

8.. Click OK, and if prompted retype the password.

Give specific users access to protected ranges

You must have Windows 2000 to give specific users access to ranges.

1.. On the Tools menu, point to Protection, and then click Allow Users to
Edit Ranges. (This command is available only when the worksheet is not
protected.)

2.. Click New.

3.. In the Title box, type a title for the range you're granting access
to.

4.. In the Refers to cells box, type an equal sign (=), and then type a
reference or select the range.

5.. In the Range password box, type a password to access the range.

The password is optional; if you don't supply a password, any user will be
able to edit the cells.

6.. Click Permissions, and then click Add.

7.. Locate and select the users to whom you want to grant access. If you
want to select multiple users, hold down CTRL while you click the names.

8.. Click OK twice, and if prompted retype the password.

9.. Repeat the previous steps for each range for which you're granting
access.

10.. To retain a separate record of the ranges and users, select the Paste
permissions information into a new workbook check box in the Allow Users to
Edit Ranges dialog box.

11.. Protect the worksheet: Click Protect Sheet in the Allow Users to Edit
Ranges dialog box.

12.. In the Protect Sheet dialog box, make sure the Protect worksheet and
contents of locked cells check box is selected, type a password for the
worksheet, click OK, and retype the password to confirm.

Note A sheet password is required to prevent other users from being able
to edit your designated ranges. Make sure you choose a password you can
remember, because if you lose the password, you cannot gain access to the
protected elements on the worksheet.

Protect workbook elements and files

Protect workbook elements

1.. On the Tools menu, point to Protection, and then click Protect
Workbook.

2.. Do one or more of the following:

a.. 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.

b.. To protect windows so that they are the same size and position each
time the workbook is opened, select the Windows check box.

a.. To prevent others from removing workbook protection, type a
password, click OK, and then retype the password to confirm it.

Protect a shared workbook

1.. If the workbook is already shared, and you want to assign a password
to protect the sharing, unshare the workbook.

How?

1.. Have all other users save and close the shared workbook. If other
users are editing, they will lose any unsaved work.
2.. Unsharing the workbook deletes the change history. If you want to
keep a copy of this information, print out the History worksheet or copy it
to another workbook.
How?

1.. On the Tools menu, point to Track Changes, and then click
Highlight Changes.
2.. In the When box, click All.
3.. Clear the Who and Where check boxes.
4.. Select the List changes on a new sheet check box, and then click
OK.
5.. Do one or more of the following:
a.. To print the History worksheet, click Print .
b.. To copy the history to another workbook, select the cells you
want to copy, click Copy , switch to another workbook, click where you want
the copy to go, and click Paste .
Note You may also want to save or print the current version of the
workbook, because this history might not apply to later versions. For
example, cell locations, including row numbers, in the copied history may no
longer be current.

3.. On the Tools menu, click Share Workbook, and then click the Editing
tab.
4.. Make sure that you are the only person listed in the Who has this
workbook open now box.
5.. Clear the Allow changes by more than one user at the same time check
box.
If this check box is not available, you must unprotect the workbook
before clearing the check box.

How?

1.. Click OK, point to Protection on the Tools menu, and then click
Unprotect Shared Workbook.
2.. Enter the password if prompted, and then click OK.
3.. On the Tools menu, click Share Workbook, and then click the
Editing tab.
6.. When prompted about the effects on other users, click Yes.
2.. Set other types of protection if you want: Give specific users access
to ranges, protect worksheets, protect workbook elements, and set passwords
for viewing and editing.

3.. On the Tools menu, point to Protection, and then click Protect Shared
Workbook or Protect and Share Workbook.

4.. Select the Sharing with track changes check box.

5.. If you want to require other users to supply a password to turn off
the change history or remove the workbook from shared use, type the password
in the Password box, and then retype the password when prompted.

6.. If prompted, save the workbook.

Protect a workbook file from viewing or editing

1.. On the File menu, click Save As.

2.. On the Tools menu, click General Options.

3.. Do either or both of the following:

a.. If you want users to enter a password before they can view the
workbook, type a password in the Password to open box, and then click OK.

b.. If you want users to enter a password before they can save changes
to the workbook, type a password in the Password to modify box, and then
click OK.

4.. When prompted, retype your passwords to confirm them.

5.. Click Save.

6.. If prompted, click Yes to replace the existing workbook.



--
Don Guillett
SalesAid Software
[email protected]
"Dan B" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> I'm using Excel 2003. I need to know what the purpose of Protect Workbook
> is under Tools | Protection. It gives 2 options, protect workbook for
> Structure and Windows.
>
> I understand the options and functionality under Protect Worksheet, and I
> thought that the Protect Workbook option would do the same for the whole
> workbook instead of individual worksheets.
>
> When trying this out, I protected a workbook, saved it, but was still able
> to edit it and resave without having to put in a password or even
unprotect
> it.
>
> So, what does Protect Workbook do and what are the Structure and Windows
> options for.
>
> Thanks,
>
> Dan
>
>

That was a great answer. It covered everything I needed.
Thanks Don!!



"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> from help
> Password protect a worksheet or workbook
> Protect worksheet elements
>
> Protect worksheet elements from all users
>
> 1.. Switch to the worksheet you want to protect.
>
> 2.. Unlock any cells you want users to be able to change: select each
> cell
> or range, click Cells on the Format menu, click the Protection tab, and
> then
> clear the Locked check box.
>
> 3.. Hide any formulas that you don't want to be visible: select the cells
> with the formulas, click Cells on the Format menu, click the Protection
> tab,
> and then select the Hidden check box.
>
> 4.. Unlock any graphic objects you want users to be able to change.
>
> How?
>
> You don't need to unlock buttons or controls for users to be able to
> click
> and use them. You can unlock embedded charts, text boxes, and other
> objects
> created with the drawing tools that you want users to be able to modify.
> To
> see which elements on a worksheet are graphic objects, click Go To on the
> Edit menu, click Special, and then click Objects.
>
> 1.. Hold down CTRL and click each object that you want to unlock.
> 2.. On the Format menu, click the command for the object you selected:
> AutoShape, Object, Text Box, Picture, Control, or WordArt.
> 3.. Click the Protection tab.
> 4.. Clear the Locked check box, and if present, clear the Lock text
> check box.
> 5.. On the Tools menu, point to Protection, and then click Protect Sheet.
>
> 6.. Type a password for the sheet.
>
> Note The password is optional; however, if you don't supply a password,
> any user will be able to unprotect the sheet and change the protected
> elements. Make sure you choose a password you can remember, because if you
> lose the password, you cannot gain access to the protected elements on the
> worksheet.
>
> 7.. In the Allow all users of this worksheet to list, select the elements
> that you want users to be able to change.
>
> 8.. Click OK, and if prompted retype the password.
>
> Give specific users access to protected ranges
>
> You must have Windows 2000 to give specific users access to ranges.
>
> 1.. On the Tools menu, point to Protection, and then click Allow Users to
> Edit Ranges. (This command is available only when the worksheet is not
> protected.)
>
> 2.. Click New.
>
> 3.. In the Title box, type a title for the range you're granting access
> to.
>
> 4.. In the Refers to cells box, type an equal sign (=), and then type a
> reference or select the range.
>
> 5.. In the Range password box, type a password to access the range.
>
> The password is optional; if you don't supply a password, any user will
> be
> able to edit the cells.
>
> 6.. Click Permissions, and then click Add.
>
> 7.. Locate and select the users to whom you want to grant access. If you
> want to select multiple users, hold down CTRL while you click the names.
>
> 8.. Click OK twice, and if prompted retype the password.
>
> 9.. Repeat the previous steps for each range for which you're granting
> access.
>
> 10.. To retain a separate record of the ranges and users, select the
> Paste
> permissions information into a new workbook check box in the Allow Users
> to
> Edit Ranges dialog box.
>
> 11.. Protect the worksheet: Click Protect Sheet in the Allow Users to
> Edit
> Ranges dialog box.
>
> 12.. In the Protect Sheet dialog box, make sure the Protect worksheet and
> contents of locked cells check box is selected, type a password for the
> worksheet, click OK, and retype the password to confirm.
>
> Note A sheet password is required to prevent other users from being able
> to edit your designated ranges. Make sure you choose a password you can
> remember, because if you lose the password, you cannot gain access to the
> protected elements on the worksheet.
>
> Protect workbook elements and files
>
> Protect workbook elements
>
> 1.. On the Tools menu, point to Protection, and then click Protect
> Workbook.
>
> 2.. Do one or more of the following:
>
> a.. 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.
>
> b.. To protect windows so that they are the same size and position each
> time the workbook is opened, select the Windows check box.
>
> a.. To prevent others from removing workbook protection, type a
> password, click OK, and then retype the password to confirm it.
>
> Protect a shared workbook
>
> 1.. If the workbook is already shared, and you want to assign a password
> to protect the sharing, unshare the workbook.
>
> How?
>
> 1.. Have all other users save and close the shared workbook. If other
> users are editing, they will lose any unsaved work.
> 2.. Unsharing the workbook deletes the change history. If you want to
> keep a copy of this information, print out the History worksheet or copy
> it
> to another workbook.
> How?
>
> 1.. On the Tools menu, point to Track Changes, and then click
> Highlight Changes.
> 2.. In the When box, click All.
> 3.. Clear the Who and Where check boxes.
> 4.. Select the List changes on a new sheet check box, and then click
> OK.
> 5.. Do one or more of the following:
> a.. To print the History worksheet, click Print .
> b.. To copy the history to another workbook, select the cells you
> want to copy, click Copy , switch to another workbook, click where you
> want
> the copy to go, and click Paste .
> Note You may also want to save or print the current version of the
> workbook, because this history might not apply to later versions. For
> example, cell locations, including row numbers, in the copied history may
> no
> longer be current.
>
> 3.. On the Tools menu, click Share Workbook, and then click the Editing
> tab.
> 4.. Make sure that you are the only person listed in the Who has this
> workbook open now box.
> 5.. Clear the Allow changes by more than one user at the same time
> check
> box.
> If this check box is not available, you must unprotect the workbook
> before clearing the check box.
>
> How?
>
> 1.. Click OK, point to Protection on the Tools menu, and then click
> Unprotect Shared Workbook.
> 2.. Enter the password if prompted, and then click OK.
> 3.. On the Tools menu, click Share Workbook, and then click the
> Editing tab.
> 6.. When prompted about the effects on other users, click Yes.
> 2.. Set other types of protection if you want: Give specific users access
> to ranges, protect worksheets, protect workbook elements, and set
> passwords
> for viewing and editing.
>
> 3.. On the Tools menu, point to Protection, and then click Protect Shared
> Workbook or Protect and Share Workbook.
>
> 4.. Select the Sharing with track changes check box.
>
> 5.. If you want to require other users to supply a password to turn off
> the change history or remove the workbook from shared use, type the
> password
> in the Password box, and then retype the password when prompted.
>
> 6.. If prompted, save the workbook.
>
> Protect a workbook file from viewing or editing
>
> 1.. On the File menu, click Save As.
>
> 2.. On the Tools menu, click General Options.
>
> 3.. Do either or both of the following:
>
> a.. If you want users to enter a password before they can view the
> workbook, type a password in the Password to open box, and then click OK.
>
> b.. If you want users to enter a password before they can save changes
> to the workbook, type a password in the Password to modify box, and then
> click OK.
>
> 4.. When prompted, retype your passwords to confirm them.
>
> 5.. Click Save.
>
> 6.. If prompted, click Yes to replace the existing workbook.
>
>
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Dan B" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi,
>>
>> I'm using Excel 2003. I need to know what the purpose of Protect
>> Workbook
>> is under Tools | Protection. It gives 2 options, protect workbook for
>> Structure and Windows.
>>
>> I understand the options and functionality under Protect Worksheet, and I
>> thought that the Protect Workbook option would do the same for the whole
>> workbook instead of individual worksheets.
>>
>> When trying this out, I protected a workbook, saved it, but was still
>> able
>> to edit it and resave without having to put in a password or even
> unprotect
>> it.
>>
>> So, what does Protect Workbook do and what are the Structure and Windows
>> options for.
>>
>> Thanks,
>>
>> Dan
>>
>>
>
>
>

glad to help you find help

--
Don Guillett
SalesAid Software
[email protected]
"Dan B" <[email protected]> wrote in message
news:[email protected]...
> That was a great answer. It covered everything I needed.
> Thanks Don!!
>
>
>
> "Don Guillett" <[email protected]> wrote in message
> news:%[email protected]...
> > from help
> > Password protect a worksheet or workbook
> > Protect worksheet elements
> >
> > Protect worksheet elements from all users
> >
> > 1.. Switch to the worksheet you want to protect.
> >
> > 2.. Unlock any cells you want users to be able to change: select each
> > cell
> > or range, click Cells on the Format menu, click the Protection tab, and
> > then
> > clear the Locked check box.
> >
> > 3.. Hide any formulas that you don't want to be visible: select the
cells
> > with the formulas, click Cells on the Format menu, click the Protection
> > tab,
> > and then select the Hidden check box.
> >
> > 4.. Unlock any graphic objects you want users to be able to change.
> >
> > How?
> >
> > You don't need to unlock buttons or controls for users to be able to
> > click
> > and use them. You can unlock embedded charts, text boxes, and other
> > objects
> > created with the drawing tools that you want users to be able to modify.
> > To
> > see which elements on a worksheet are graphic objects, click Go To on
the
> > Edit menu, click Special, and then click Objects.
> >
> > 1.. Hold down CTRL and click each object that you want to unlock.
> > 2.. On the Format menu, click the command for the object you
selected:
> > AutoShape, Object, Text Box, Picture, Control, or WordArt.
> > 3.. Click the Protection tab.
> > 4.. Clear the Locked check box, and if present, clear the Lock text
> > check box.
> > 5.. On the Tools menu, point to Protection, and then click Protect
Sheet.
> >
> > 6.. Type a password for the sheet.
> >
> > Note The password is optional; however, if you don't supply a
password,
> > any user will be able to unprotect the sheet and change the protected
> > elements. Make sure you choose a password you can remember, because if
you
> > lose the password, you cannot gain access to the protected elements on
the
> > worksheet.
> >
> > 7.. In the Allow all users of this worksheet to list, select the
elements
> > that you want users to be able to change.
> >
> > 8.. Click OK, and if prompted retype the password.
> >
> > Give specific users access to protected ranges
> >
> > You must have Windows 2000 to give specific users access to ranges.
> >
> > 1.. On the Tools menu, point to Protection, and then click Allow Users
to
> > Edit Ranges. (This command is available only when the worksheet is not
> > protected.)
> >
> > 2.. Click New.
> >
> > 3.. In the Title box, type a title for the range you're granting access
> > to.
> >
> > 4.. In the Refers to cells box, type an equal sign (=), and then type a
> > reference or select the range.
> >
> > 5.. In the Range password box, type a password to access the range.
> >
> > The password is optional; if you don't supply a password, any user will
> > be
> > able to edit the cells.
> >
> > 6.. Click Permissions, and then click Add.
> >
> > 7.. Locate and select the users to whom you want to grant access. If
you
> > want to select multiple users, hold down CTRL while you click the names.
> >
> > 8.. Click OK twice, and if prompted retype the password.
> >
> > 9.. Repeat the previous steps for each range for which you're granting
> > access.
> >
> > 10.. To retain a separate record of the ranges and users, select the
> > Paste
> > permissions information into a new workbook check box in the Allow Users
> > to
> > Edit Ranges dialog box.
> >
> > 11.. Protect the worksheet: Click Protect Sheet in the Allow Users to
> > Edit
> > Ranges dialog box.
> >
> > 12.. In the Protect Sheet dialog box, make sure the Protect worksheet
and
> > contents of locked cells check box is selected, type a password for the
> > worksheet, click OK, and retype the password to confirm.
> >
> > Note A sheet password is required to prevent other users from being
able
> > to edit your designated ranges. Make sure you choose a password you can
> > remember, because if you lose the password, you cannot gain access to
the
> > protected elements on the worksheet.
> >
> > Protect workbook elements and files
> >
> > Protect workbook elements
> >
> > 1.. On the Tools menu, point to Protection, and then click Protect
> > Workbook.
> >
> > 2.. Do one or more of the following:
> >
> > a.. 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.
> >
> > b.. To protect windows so that they are the same size and position
each
> > time the workbook is opened, select the Windows check box.
> >
> > a.. To prevent others from removing workbook protection, type a
> > password, click OK, and then retype the password to confirm it.
> >
> > Protect a shared workbook
> >
> > 1.. If the workbook is already shared, and you want to assign a
password
> > to protect the sharing, unshare the workbook.
> >
> > How?
> >
> > 1.. Have all other users save and close the shared workbook. If other
> > users are editing, they will lose any unsaved work.
> > 2.. Unsharing the workbook deletes the change history. If you want to
> > keep a copy of this information, print out the History worksheet or copy
> > it
> > to another workbook.
> > How?
> >
> > 1.. On the Tools menu, point to Track Changes, and then click
> > Highlight Changes.
> > 2.. In the When box, click All.
> > 3.. Clear the Who and Where check boxes.
> > 4.. Select the List changes on a new sheet check box, and then
click
> > OK.
> > 5.. Do one or more of the following:
> > a.. To print the History worksheet, click Print .
> > b.. To copy the history to another workbook, select the cells you
> > want to copy, click Copy , switch to another workbook, click where you
> > want
> > the copy to go, and click Paste .
> > Note You may also want to save or print the current version of
the
> > workbook, because this history might not apply to later versions. For
> > example, cell locations, including row numbers, in the copied history
may
> > no
> > longer be current.
> >
> > 3.. On the Tools menu, click Share Workbook, and then click the
Editing
> > tab.
> > 4.. Make sure that you are the only person listed in the Who has this
> > workbook open now box.
> > 5.. Clear the Allow changes by more than one user at the same time
> > check
> > box.
> > If this check box is not available, you must unprotect the workbook
> > before clearing the check box.
> >
> > How?
> >
> > 1.. Click OK, point to Protection on the Tools menu, and then click
> > Unprotect Shared Workbook.
> > 2.. Enter the password if prompted, and then click OK.
> > 3.. On the Tools menu, click Share Workbook, and then click the
> > Editing tab.
> > 6.. When prompted about the effects on other users, click Yes.
> > 2.. Set other types of protection if you want: Give specific users
access
> > to ranges, protect worksheets, protect workbook elements, and set
> > passwords
> > for viewing and editing.
> >
> > 3.. On the Tools menu, point to Protection, and then click Protect
Shared
> > Workbook or Protect and Share Workbook.
> >
> > 4.. Select the Sharing with track changes check box.
> >
> > 5.. If you want to require other users to supply a password to turn off
> > the change history or remove the workbook from shared use, type the
> > password
> > in the Password box, and then retype the password when prompted.
> >
> > 6.. If prompted, save the workbook.
> >
> > Protect a workbook file from viewing or editing
> >
> > 1.. On the File menu, click Save As.
> >
> > 2.. On the Tools menu, click General Options.
> >
> > 3.. Do either or both of the following:
> >
> > a.. If you want users to enter a password before they can view the
> > workbook, type a password in the Password to open box, and then click
OK.
> >
> > b.. If you want users to enter a password before they can save
changes
> > to the workbook, type a password in the Password to modify box, and then
> > click OK.
> >
> > 4.. When prompted, retype your passwords to confirm them.
> >
> > 5.. Click Save.
> >
> > 6.. If prompted, click Yes to replace the existing workbook.
> >
> >
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Dan B" <[email protected]> wrote in message
> > news:%[email protected]...
> >> Hi,
> >>
> >> I'm using Excel 2003. I need to know what the purpose of Protect
> >> Workbook
> >> is under Tools | Protection. It gives 2 options, protect workbook for
> >> Structure and Windows.
> >>
> >> I understand the options and functionality under Protect Worksheet, and
I
> >> thought that the Protect Workbook option would do the same for the
whole
> >> workbook instead of individual worksheets.
> >>
> >> When trying this out, I protected a workbook, saved it, but was still
> >> able
> >> to edit it and resave without having to put in a password or even
> > unprotect
> >> it.
> >>
> >> So, what does Protect Workbook do and what are the Structure and
Windows
> >> options for.
> >>
> >> Thanks,
> >>
> >> Dan
> >>
> >>
> >
> >
> >
>
>