Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a worksheet, but allowing user to add rows in a table | Excel Worksheet Functions | |||
locking text in a cell, but allowing new text to be added | New Users to Excel | |||
Locking cells in a spreadsheet | Excel Discussion (Misc queries) | |||
need help with locking spreadsheet | Excel Discussion (Misc queries) | |||
Locking formula for a Sort | Excel Discussion (Misc queries) |