Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Security
Is it possible to lock access to a cell or cell range?
I know it is possible to lock a cell range and then protect the worksheet, but the locked and protected range can still be referred to, even if I disallow selecting of locked cells. I.e. if I lock and protect Column A, disallowing selection of locked cells; a user can insert a formula in an unlocked cell that referrs to the locked cell, by typing, e.g. "=a1." Maybe this is possible in Excel 2007 but not in my version (2003). Thanks, Mark |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Security
Maybe this is possible in Excel 2007
No more than in 2003. Meaning that maybe you could do something kludgey with a sheet change event macro, but macros can be disabled so it's hardly fail safe. -- Jim "richarmk" wrote in message ... | Is it possible to lock access to a cell or cell range? | | I know it is possible to lock a cell range and then protect the worksheet, | but the locked and protected range can still be referred to, even if I | disallow selecting of locked cells. | | I.e. if I lock and protect Column A, disallowing selection of locked cells; | a user can insert a formula in an unlocked cell that referrs to the locked | cell, by typing, e.g. "=a1." | | Maybe this is possible in Excel 2007 but not in my version (2003). | Thanks, | Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security | Excel Discussion (Misc queries) | |||
Worksheet Security/Cell Protection | Excel Worksheet Functions | |||
macro security | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Cell Security not maintained | Excel Discussion (Misc queries) |