prevent cell values modification after saving the worksheet.

**bittu2010** · 01-08-2012, 04:16 PM

Hi All,

I want to prevent cell value modification for example if I write “A or anything in cell “A1” then … after writing and saving the file I and anyone else should not be able to delete or modify its value.

Means the cell which have contain a value should not be deleted/modified by anyone and blank cell should be able to write and edit for anytime by anyone but when blank cell get a value & worksheet get saved then it should not be deleted/modified.

Please help me to get this one.. Thanks in advance .

Regards,

Javed Khan

**bittu2010** · 01-08-2012, 09:40 PM

Hi I am still waiting for an answer :-(

I have assigned to complete this assignment in office

Thanks all.. I hope a help will be come soon :-)

**john55** · 01-09-2012, 12:26 AM

hi

as an option, try it and change for your needs

Please Login or Register  to view this content.

**bittu2010** · 01-09-2012, 12:46 AM

You are amazing John , Genius .. Thanks A lot for this buddy.. Thanks A lot once again ..

I wish I could have done something good for you. Take care of you. You are precious.

**bittu2010** · 01-09-2012, 12:51 AM

what does it mean " You must spread some Reputation around before giving it to john55 again." when I am clicking on Star button ??

**john55** · 01-09-2012, 03:12 AM

you're welcome!

this is a place where we help each other!
yes, you can not show your appreciation twice (one after the other) for the same user even if the thread is different!