Hi,
Is there any way useing vba code that we can protect particular cells value from deleting
Hi,
Is there any way useing vba code that we can protect particular cells value from deleting
Lock those cells (Format>Cells>Protection) and protect the sheet (Tools>Protection>Protect Sheet...).
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Actually i am in need of a mecro, that can protect a sheet instead of useing tool|protect...
pls help with code
thanks
[vba]
Worksheets("sheet_name").Protect Password:="mypassword"
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber