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"
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.