| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect formula
I have a excel spread sheet that I have Protect all formula but in this one
roll I have this formula =SUM(G45) but what I need to do is let others add to the formula like =SUM(G45)+2000+3000 so I need to Protect this =SUM(G45) and let them add to it Hope some one can help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Protect formula
Wouldn't it be better to create an input range, say in G46:G50, or even
G145:G150, where users can enter these additional values? Change your formula to =SUM(G45:G50), or =G45+SUM(G145:G150) "joen" wrote: I have a excel spread sheet that I have Protect all formula but in this one roll I have this formula =SUM(G45) but what I need to do is let others add to the formula like =SUM(G45)+2000+3000 so I need to Protect this =SUM(G45) and let them add to it Hope some one can help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect formula | Excel Discussion (Misc queries) | |||
| Protect formatting & formula | Excel Discussion (Misc queries) | |||
| protect formula in cell and still allow data deletion | Excel Discussion (Misc queries) | |||
| How do I protect a formula from "accidently" being changed in Exc. | Excel Worksheet Functions | |||
| how do I protect a formula in an excel speadsheet | Excel Worksheet Functions | |||
Linear Mode
