Protect cell pls help...

[Guest]

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

 

[Don Guillett]

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

 

[Shailesh Shah]

You keep seprate master sheet of your all item codes & use data
validation in your stock list sheet.

See below Topics from Debra Dalgleish's site for the Data Validation &
one example for order form.

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlOrderForm01.html


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

 

[Guest]

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

 

[Guest]

Thanks Shailesh Shah for reply

I can't keep seprate master sheet. I have to add or delete items of all the
product code so i have put all product codes together with item and to view
all of them together.

Thanks
Tiya
"" Shailesh Shahwrote: