View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default HOWTO DELETE UNLOCK CELLS

I'm looking for a way to delete unlocked cells in a worksheet without using
formulas,macro... This is the thing : locked cells are written and don't
change,
unlocked cells are to write on them, print and erase the context to write
again of course.Also the sheet is protected with the purpose of keeping the
locked cells with the text that does not change. My 2 options :1- copy the
worksheet with the empty unlocked cells and write in them everytime in
different sheet or 2- do what I call tab-delet, tab-delete, tab-delete until
all unlocked cells are deleted ( effective but long proccess). Is there a
better 3er options or I'm asking too much from excel ?TX.