Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a Macro override sheet Protection?
Hi.
I have a sheet in which i want to protect the formulas being used for calculations. In this sheet however, there is VBA coding/automatically running macros that changes the formulas depending on what option is checked in a validated list. This makes excel unhappy, and i get a run-time error... i'm assuming it is because the protection is preventing formula changes. So the question is: what can i do to allow the code to change the formulas, while not letting the user change them manually. ie. if "module width" is selected Area (in cell a1) = Module width x Total height if "module height" is selected Area (in cell a1) = total width x module height etc. any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheet protection | Excel Discussion (Misc queries) | |||
sheet Protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Worksheet Functions | |||
Sheet Protection | Excel Worksheet Functions |