#1   Report Post  
Paul Cooling
 
Posts: n/a
Default Protecting Workbook

Can someone please help to explain what the difference is
between protect sheet and protect workbook.

Many thanks in advance

Paul
  #2   Report Post  
Paul B
 
Posts: n/a
Default

Paul, form excel help,

weorksheet protecting
Protecting elements from all users You can prevent users from inserting,
deleting, and formatting rows and columns, from changing the contents of
locked cells, and from moving the cursor to cells that are locked or to
cells that are unlocked.

By default all cells on a worksheet are locked. Before you protect a
worksheet, you can unlock cells where you want users to enter and change
data, in two ways. To unlock cells for all users, you can use the Protection
tab of the Format Cells dialog box. To unlock cells for specific users, you
can use the Allow Users to Edit Ranges dialog box. Any ranges that you
specify in this dialog box and don't assign a password for are also unlocked
for all users. The cells you leave locked become protected only after you
protect the worksheet.

Other worksheet features and elements for which you can restrict access for
all users include hyperlinks, sorting, AutoFiltering, PivotTable reports,
graphic objects, and scenarios. These protections apply to all users and the
entire worksheet, not to individual users or data ranges.

For chart sheets, you can protect the contents of the chart from changes,
and you can protect any graphic objects on the sheet, such as text boxes,
from being changed or deleted. A protected chart sheet continues to be
updated whenever the source data for the chart changes.

Giving specific users access to protected ranges If you have the Windows
2000 operating system, you can allow specific users to edit specific cells
or ranges. Users to whom you grant access can edit the cells even if the
cells are locked. Your access restrictions take effect only after you
protect the worksheet.

The users you specify in the Permissions for range dialog box can
automatically edit the range without entering the password. Other users are
prompted for the password, and users who enter the password can then edit
the range. If a cell belongs to more than one range, users who are
authorized to edit any of the ranges can then edit the cell. If a user
attempts to edit multiple cells at once and is authorized to edit some but
not all of those cells, the user will be prompted to select and edit the
cells one by one.

workbook protecting
Protecting workbook elements and files

Protecting workbook elements You can prevent users from adding or deleting
worksheets, or displaying hidden worksheets. You can also prevent users from
changing the sizes or positions of the windows you set up to display a
workbook. These protections apply to the entire workbook.

To hide an entire workbook so that users can't see it but can gain access to
contents such as macros, use the Hide command on the Window menu, and then
save the hidden workbook.

Protecting a shared workbook You can protect a shared workbook so that
users cannot return it to exclusive use or delete the change history log. If
you want to require a password to remove this type of protection, you must
apply the protection before you share the workbook. Applying the protection
automatically turns on sharing. Unprotecting these features turns off
sharing and deletes all of the saved change history.

Alternatively, you can protect the sharing and change history without a
password. You can apply this protection when a workbook is already shared,
and then unprotecting won't turn off sharing or delete the change history.

file protecting
Protecting a workbook file from viewing and editing You can restrict who
can open and use the data in a workbook file by requiring a password to view
or save changes to the file. You can set two separate passwords, one that
users must enter to open and view the file, and another that users must
enter before they can edit and save changes to the file. These passwords
apply to the workbook file and are separate from the protection provided by
the Protect Workbook dialog box.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul Cooling" wrote in message
...
Can someone please help to explain what the difference is
between protect sheet and protect workbook.

Many thanks in advance

Paul



  #3   Report Post  
Paul Cooling
 
Posts: n/a
Default

Thanks for your help - really appreciate it - very well
explained!!

Paul


-----Original Message-----
Paul, form excel help,

weorksheet protecting
Protecting elements from all users You can prevent

users from inserting,
deleting, and formatting rows and columns, from changing

the contents of
locked cells, and from moving the cursor to cells that

are locked or to
cells that are unlocked.

By default all cells on a worksheet are locked. Before

you protect a
worksheet, you can unlock cells where you want users to

enter and change
data, in two ways. To unlock cells for all users, you can

use the Protection
tab of the Format Cells dialog box. To unlock cells for

specific users, you
can use the Allow Users to Edit Ranges dialog box. Any

ranges that you
specify in this dialog box and don't assign a password

for are also unlocked
for all users. The cells you leave locked become

protected only after you
protect the worksheet.

Other worksheet features and elements for which you can

restrict access for
all users include hyperlinks, sorting, AutoFiltering,

PivotTable reports,
graphic objects, and scenarios. These protections apply

to all users and the
entire worksheet, not to individual users or data ranges.

For chart sheets, you can protect the contents of the

chart from changes,
and you can protect any graphic objects on the sheet,

such as text boxes,
from being changed or deleted. A protected chart sheet

continues to be
updated whenever the source data for the chart changes.

Giving specific users access to protected ranges If you

have the Windows
2000 operating system, you can allow specific users to

edit specific cells
or ranges. Users to whom you grant access can edit the

cells even if the
cells are locked. Your access restrictions take effect

only after you
protect the worksheet.

The users you specify in the Permissions for range dialog

box can
automatically edit the range without entering the

password. Other users are
prompted for the password, and users who enter the

password can then edit
the range. If a cell belongs to more than one range,

users who are
authorized to edit any of the ranges can then edit the

cell. If a user
attempts to edit multiple cells at once and is authorized

to edit some but
not all of those cells, the user will be prompted to

select and edit the
cells one by one.

workbook protecting
Protecting workbook elements and files

Protecting workbook elements You can prevent users from

adding or deleting
worksheets, or displaying hidden worksheets. You can also

prevent users from
changing the sizes or positions of the windows you set up

to display a
workbook. These protections apply to the entire workbook.

To hide an entire workbook so that users can't see it but

can gain access to
contents such as macros, use the Hide command on the

Window menu, and then
save the hidden workbook.

Protecting a shared workbook You can protect a shared

workbook so that
users cannot return it to exclusive use or delete the

change history log. If
you want to require a password to remove this type of

protection, you must
apply the protection before you share the workbook.

Applying the protection
automatically turns on sharing. Unprotecting these

features turns off
sharing and deletes all of the saved change history.

Alternatively, you can protect the sharing and change

history without a
password. You can apply this protection when a workbook

is already shared,
and then unprotecting won't turn off sharing or delete

the change history.

file protecting
Protecting a workbook file from viewing and editing You

can restrict who
can open and use the data in a workbook file by requiring

a password to view
or save changes to the file. You can set two separate

passwords, one that
users must enter to open and view the file, and another

that users must
enter before they can edit and save changes to the file.

These passwords
apply to the workbook file and are separate from the

protection provided by
the Protect Workbook dialog box.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can

benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul Cooling" wrote in message
...
Can someone please help to explain what the difference

is
between protect sheet and protect workbook.

Many thanks in advance

Paul



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 11:12 PM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 09:31 PM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 02:07 AM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 04:05 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"