| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
... After I protected my worksheet, some cells can be changed...
I applied some protection i a worksheet and most of the cells work propoerly.
I can enter data where I want to, I'm restricted from entering data in some cells, my formulas can't be changed except in two columns of cells. I have two columns of cells that have a simple formula, =$N$2 , besides that the cells are formated for percentages. I can click into any of the cells in these two columns and type anythin I want. Is there an issue with protection when using =$N$2 or percentages. Darrell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macros on protected worksheet | Excel Worksheet Functions | |||
| Run macros on protected worksheet | Excel Worksheet Functions | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
