View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Excell 2007 setup

"My version has "Protect Sheet" or "Protect Workbook", what is the
difference." Broadly:-

Protect Workbook means that you will not be able to get into the Workbook,
at all, unless you know the password.

Protect Worksheet means that you will be able to get into the Workbook but
you will not be able to get into the parts of it that have been restricted.
This means that you will be able to, "see" some parts of the Workbook but not
the parts that have been restricted.

Please hit Yes if my comments have helped.

Thanks.




"Daryl" wrote:

How do I setup a spreadsheet to be read only, unless you know the password,
but allow sorting by other users? in my prior version when you were opening
the file it said "Read Only" recomended or "open" which required the
password. Also under the Review Tab, Excell 2007 help talks about "protect
document" selection. My version has "Protect Sheet" or "Protect Workbook",
what is the difference.
--
Daryl