View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
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.