View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bryce Bryce is offline
external usenet poster
 
Posts: 24
Default Protection, cutting cells

Hello

Is there anyway to stop users from being able to cut cell content, but still
be able to copy it?

I have set up a timesheet which calulates total time for the day using date
validation (with a list of times on a separate sheet), with all but the input
cells unlocked and sheet protected, and so far all works as intended. Start
and finish times can be copied/pasted which works well to quickly fill in the
sheet, however if the time is cut (eg input into wrong day), the cell it is
pasted into results in a #REF error for the adding up of hours for the day. -
Thanks heaps - Bryce