View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gary
 
Posts: n/a
Default Cell format protection

I have certain cells locked in a protected worksheet. The spreadsheet is
used by others who input data in unlocked cells and return to me. My
problem is that when they copy & paste something, they are eliminating the
formats I have all ready set (border, allow numbers only, etc.). Is there
any way to prevent this, while still maintaining the protection of the rest
of the locked cells?