You're too kind.
thanks for the feed back.
It's a hobby and a challenge for me. I always check whether the real excel
guru's
are going to come up with a better answer. That way I learn and I hope, so
do others.
So, the thanks should go to all the experts who take time to give us the
right solutions again and again.

Bill

"FC" wrote in message
...
Of course!!! I can not believe I did not think of that, but that does not
take the credit out of you, thanks a lot for the solution and for the
interest in my and averyone questions, keep up the good work. Thanks again
Bill.

"Bill Kuunders" wrote:

Give the collection of all unlocked cells a name

click onto the first, hold cntr button and klick onto the others,
while highlighted give this collection of cells a name by entering a name
in
the area just above cell a1 and push "enter"

select the name and press delete button

--
Greetings from New Zealand





"FC" wrote in message
...
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.