Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I lock cells so their values don't get updated
I have a worksheet (A) which gets updated by cell values in another worksheet
(B). Worksheet A is only valid up to a particular date. After that date, I want to be able to lock every value in the worksheet A so that I can still update worksheet B (manually) and NOT have worksheet a updated. Is there a way to do this or do I need to go to a VBA solution? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-lock a cell once it's updated | Excel Worksheet Functions | |||
Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
Lock cells for combo box values only | Excel Programming | |||
Updated cells | Excel Worksheet Functions | |||
only show updated values | New Users to Excel |