Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - prevent someone from clicking into certain cells
I received a spreadsheet in which you can only click into certain cells and
enter data. But I can't even click into the rest of the cells containing formulas etc at all. It isn't like protection, where you can click into the locked cells, but when you try to enter data a message appears indicating that the cell is locked. In the spreadsheet I received you simply cannot even click in the cells. What is this feature, and how do I turn it on? (it is functioning in both Excel 2003 and 2007). Any advice you can provide would be greatly appreciated....Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - prevent someone from clicking into certain cells
It is Worksheet Protection
As an experiment: Open a new worksheet Whichever Excel version (2003/2007) you have; start the process of worksheet protection You should see a dialog in which you can specify is uses can move to locked, to unlocked cell, to other object best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Silverstreak" wrote in message ... I received a spreadsheet in which you can only click into certain cells and enter data. But I can't even click into the rest of the cells containing formulas etc at all. It isn't like protection, where you can click into the locked cells, but when you try to enter data a message appears indicating that the cell is locked. In the spreadsheet I received you simply cannot even click in the cells. What is this feature, and how do I turn it on? (it is functioning in both Excel 2003 and 2007). Any advice you can provide would be greatly appreciated....Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mouse clicking on Excel Worksheet Cells | Excel Worksheet Functions | |||
prevent blank cells in excel | Excel Discussion (Misc queries) | |||
prevent blank cells in excel | Excel Discussion (Misc queries) | |||
Prevent Excel closing all workbook instances when clicking on "X" | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) |