PDA

View Full Version : macro for protecting cell value from deleting



rahullambe
12-11-2008, 08:42 AM
Hi,

Is there any way useing vba code that we can protect particular cells value from deleting

Bob Phillips
12-11-2008, 08:52 AM
Lock those cells (Format>Cells>Protection) and protect the sheet (Tools>Protection>Protect Sheet...).

rahullambe
12-11-2008, 09:00 AM
Actually i am in need of a mecro, that can protect a sheet instead of useing tool|protect...

pls help with code

thanks

Bob Phillips
12-11-2008, 09:11 AM
Worksheets("sheet_name").Protect Password:="mypassword"