Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i prohibit user's from accessing formulas (lock the formula
how do i lock up the formula's so that user's can not access them -- i am
trying to make a pricing formula template and i only want the users to input data and read the result --i do not want them to access any formula's or descriptive info thanks scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i prohibit user's from accessing formulas (lock the formula
select the cells containing formulas, then format - cells - protection - lock.
make sure the cells you want the user to key in are not locked - same process, just uncheck "lock". then, when you are finished, go to Tools, click Protection, and specify the protection you want. "scott" wrote: how do i lock up the formula's so that user's can not access them -- i am trying to make a pricing formula template and i only want the users to input data and read the result --i do not want them to access any formula's or descriptive info thanks scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock in formulas | Excel Worksheet Functions | |||
Lock formulas from being edited | Excel Worksheet Functions | |||
Lock formulas only not data | Excel Worksheet Functions | |||
Lock formulas in a cell | Excel Discussion (Misc queries) | |||
How do I lock cell formulas??? | Excel Discussion (Misc queries) |