... I protected the cell but I still can delete its content

You need to apply the protection via:
Tools Protection Protect Sheet Passwrd? OK

.. I was wondering if I could protect whatever cells
that I do not one to delete so that I could
select the whole worksheet to delete the rest.

Think it won't work in this way. But we could try it the other way round
where we select and unlock only the input cell range(s), then apply the
sheet protection as above.

Assuming MyRange covers the 2 input tanges

Select the entire sheet Format Cells Protection tab
Ensure "Locked" is checked OK
(This step is usually not necessary as by default all cells are checked as:
Locked.)

Select MyRange Format Cells Protection tab
Uncheck "Locked" OK

Now click Tools Protect Protect Sheet ...

The entire sheet will be protected except MyRange
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Lewis Koh" wrote
in message ...

wow, that's a nice function :) Just one click to delete the selected
cells. Thanks!!
By the way, how do I use the function protect cell? I protected the
cell but I still can delete its content. I was wondering if I could
protect whatever cells that I do not one to delete so that I could
select the whole worksheet to delete the rest.


--
Lewis Koh
------------------------------------------------------------------------
Lewis Koh's Profile:
http://www.excelforum.com/member.php...o&userid=25712
View this thread: http://www.excelforum.com/showthread...hreadid=391513