#1   Report Post  
Old January 28th 10, 01:54 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 6
Default Excell 2007 setup

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

  #2   Report Post  
Old January 28th 10, 04:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
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

  #3   Report Post  
Old January 28th 10, 06:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Excell 2007 setup

t_to_t

Your posted information is mostly incorrect.

Excel has three levels of protection.........four if you count VBAProject
protection.

1. File to open protection which requires a password to open the workbook
and allows any and all functions once opened.

Can be made read-only so's no changes can be saved.

2. Workbook protection which allows no changes to workbook structure or
windows.

Disables unhiding hidden sheets or renaming sheets among other features.

3. Worksheet protection which allows no changes made to the cells on a
worksheet.

Some cells can be unlocked while others are locked for editng.


Gord Dibben MS Excel MVP

On Thu, 28 Jan 2010 08:44:06 -0800, trip_to_tokyo
wrote:

"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


  #4   Report Post  
Old January 28th 10, 06:59 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Excell 2007 setup

Daryl

FileSave AsExcel workbookToolsGeneral Options.

Here you set a password to open and/or modify and/or set to read only
recommended.

For protect workbook and worksheet differences see my reply to trip_to_tokyo


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 17:54:01 -0800, 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.




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
printing setup issue in 2007 Zhi Sheng Excel Discussion (Misc queries) 1 November 8th 09 11:00 PM
XL 2007 setup bezdanian Setting up and Configuration of Excel 1 January 30th 09 10:42 PM
Excell Page setup Sameer[_3_] Excel Worksheet Functions 1 August 9th 07 12:48 PM
How to open MS Excell 2007 Sheet in MS Excell 2000??? Alek Luchnikov New Users to Excel 1 March 22nd 07 04:40 PM
How Can I setup data in csv format in Excell? graywolf Excel Discussion (Misc queries) 4 November 15th 06 05:16 PM


All times are GMT +1. The time now is 05:25 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017