View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default About protection of Cells

Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste!
Regards,
Stefi

Ruby ezt *rta:

I have a problem in the spreadsheet with few many data with conditional
formats.Each cell has different conditional format.When a cell is copied from
one to another the format is getting copied.How to protect the cells without
copying the conditional format?Is there any way to protect only the
conditional formatting of the cell but not the normal formatting?
--
Ruby