Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula &format protecting
I have created a timesheet that calculates flexitme ongoing totals etc(a
major acheivement for me !!) how do i protect it so that people can put anything they like in any cell they choose, so that what they input does not overwrite the format or oiginal formula or sum function etc ?. The main problem is a total column that is in turn used to calculate flexitime , the total column is not an input column as it is arrived at by a formua ,unless a person has a flexi period off in which case they put 7:24 in it. This then erases the formula. THANKS TO THE PEOPLE WHO HAVE HELPED ON PREVIOUS PROBS,AND TO THOSE WHO WILLWITH THIS ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |