View Single Post
  #1   Report Post  
Bill Schnur
 
Posts: n/a
Default Protect Cell Formatting

I have problems with users wanting to cut and paste data in the cells. How do
I protect a worksheet to keep someone from "cutting" an unlocked cell and
pasting it in another "unlocked" region. They destroy the formatting such as
borders, backcolors, etc. and make quite a mess. I would like to retain the
ability to copy the contents of the cell but not the formatting.