View Single Post
 
Old 03-31-2012, 08:28 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Excel VBA: Worksheet_Change Cells.Protect

Application Data.xlsm

I want the Date Column to be locked once the date is auto added (added once and stay forever)

In my codes, I've tried using Cells.Protect (deleted later) and at present using the codes (see in the file)

Could anyone figure out why the codes cannot protect Column Date values?
Reply With Quote