Thanks Don Guilett for reply.
Code mean a Product code. Which i don't want to delete I want to delete only
items of that prouct code. I want that prouct code column to be protect and
allowed me to delete row with autofilter is on.

Thanks
Tiya


"Don Guillett" wrote:

by code, do you mean a macro or a formula. Macros are usually referred to as
"code".
Post what you have for comments.

--
Don Guillett
SalesAid Software

"Tiya" wrote in message
...
Hi to all
I have my stock list file where i have fields like Code,Item,Descr,Qty.

What i am doing is, if some Item is sold i just remove that item,descr,qty
and not the Code. I want my code should be protected when i remove the
items.
One more thing i use autofilter to remove and add item list it don't work
when i protect them.

Is there any way i just protect my code and i can add or remove partcular
row data.
Any Help
thanks
Tiya