| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding functions
Hello again
I seem to remember someone saying that you could put all your functions in cells that are hidden way down in the bottom of a sheet somewhere so that knowone could delete or mess with them. and they would still perform the calculation in the cell intended. like if I want A5 to give me the total of A1 through A4 I could put that function in cell A300 That way if someone tries to delete the answer I don't loose the function. -- Thank You Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding functions
A300=sum(a1:a4)
A5=A300 But I think protection would be a better, easier, and more efficient way to do it. -- JNW "steve" wrote: Hello again I seem to remember someone saying that you could put all your functions in cells that are hidden way down in the bottom of a sheet somewhere so that knowone could delete or mess with them. and they would still perform the calculation in the cell intended. like if I want A5 to give me the total of A1 through A4 I could put that function in cell A300 That way if someone tries to delete the answer I don't loose the function. -- Thank You Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding functions
Ok thanks again I will try both ways
-- Thank You Steve "JNW" wrote: A300=sum(a1:a4) A5=A300 But I think protection would be a better, easier, and more efficient way to do it. -- JNW "steve" wrote: Hello again I seem to remember someone saying that you could put all your functions in cells that are hidden way down in the bottom of a sheet somewhere so that knowone could delete or mess with them. and they would still perform the calculation in the cell intended. like if I want A5 to give me the total of A1 through A4 I could put that function in cell A300 That way if someone tries to delete the answer I don't loose the function. -- Thank You Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
