Locking a spreadsheet, yet allowing sort
 

Hello,
I'm sure there are discussions somewhere on here that answer this, but I
don't know how to phrase the questions. Please refer me to any relevant
discussions.

I need to put a spreadsheet on a website (or a link to it) for the world to
see. There won't be any formulas, just data in the cells--it's a directory. I
don't want end users to be able to tamper with the data, but I would like
them to be able to sort. Also, there will be hyperlinks in many of the cells.

Also, is there a way to prevent someone from copy/pasting the data, or
saving the spreadsheet to their own compter? The goal is to bring the end
user back to the website to view the information.

Any help at all that you can offer is most appreciated!

Locking a spreadsheet, yet allowing sort
 

Your options depend on your version of Excel and the user's too.

To initially protect Select ToolsProtectProtect Sheet and in the dialog
box which appears choose a password.

If you are using Xl2003 you will have the option to refine the Protection.
Scroll down and check Sort, then click OK.

See this link for further info
http://support.microsoft.com/kb/826923 Description of options that help you
protect your worksheets in Excel 2003 and Excel 2002

Paul


"WashtenawWeddings.com"
wrote in message ...
Hello,
I'm sure there are discussions somewhere on here that answer this, but I
don't know how to phrase the questions. Please refer me to any relevant
discussions.

I need to put a spreadsheet on a website (or a link to it) for the world
to
see. There won't be any formulas, just data in the cells--it's a
directory. I
don't want end users to be able to tamper with the data, but I would like
them to be able to sort. Also, there will be hyperlinks in many of the
cells.

Also, is there a way to prevent someone from copy/pasting the data, or
saving the spreadsheet to their own compter? The goal is to bring the end
user back to the website to view the information.

Any help at all that you can offer is most appreciated!