Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to tamper proof cells?
Hi,
I have a spreadsheet that I want to send to someone so they can enter some data. The cells that I want them to enter data to are coloured to identify the data entry cells. How can I make sure they don't tamper with the other cells I don't want them to touch. Any ideas? thanks F |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to tamper proof cells?
First, unlock the cells that you want them to be able to enter data into
(your highlighted cells). Follow these steps: 1. Select the cells to unlock 2. From the Format Menu, choose "Cells" 3. Select the "Protection" Tab 4. Uncheck the "Locked" box 5. Click OK Next, Protect the Worksheet: 1. From the Tools Menu, choose "Protection" 2. Select "Protect Sheet" 3. Enter a Password if you want or leave blank 4. Click OK Thats it! Users may now only enter data into the Unprotected Cells. If you need to make changes later, simply select "Tools" then "Protection" then "Unprotect Sheet". HTH, Elkar "flint" wrote: Hi, I have a spreadsheet that I want to send to someone so they can enter some data. The cells that I want them to enter data to are coloured to identify the data entry cells. How can I make sure they don't tamper with the other cells I don't want them to touch. Any ideas? thanks F |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
I need complete idiot proof excel setup database help. please | New Users to Excel | |||
Offset() returns reference, first not value (proof) | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |