View Single Post
  #1   Report Post  
stuck!
 
Posts: n/a
Default 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 !