| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Secure spreadsheet
I would like to give some clients an excell 2003 spreadsheet wich has
formulas and code in it. What is the best way to secure it so only they can type in some cells ect without being able to read the formulas. I know nothing is secure these day given time and money, but what is the best we can do or what options do i have. Regards Don Grover |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Secure spreadsheet
You can achieve limited protection by going to Forma, Cells then select the
Protection tab. Locked cells will not be changeable once the sheet is protected and hidden cells will hide any formulae in cells. "Don Grover" wrote: I would like to give some clients an excell 2003 spreadsheet wich has formulas and code in it. What is the best way to secure it so only they can type in some cells ect without being able to read the formulas. I know nothing is secure these day given time and money, but what is the best we can do or what options do i have. Regards Don Grover |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Big problem with excel recalculating spreadsheet | Excel Discussion (Misc queries) | |||
| Linked Spreadsheet Opens | Excel Discussion (Misc queries) | |||
| summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions | |||
| Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
Linear Mode
