Excel VBA: Worksheet_Change Cells.Protect

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Excel VBA: Worksheet_Change Cells.Protect

FAQ

Thread Tools

Display Modes

03-31-2012, 08:28 AM

tinfanide

Windows 7 64bit Excel VBA: Worksheet_Change Cells.Protect

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protect / Lock Cells / Print Set-up?	meggenm	Excel	3	01-26-2012 09:57 PM
protect and unprotect in shared excel	mark-gabb	Excel	0	01-09-2012 07:30 PM
Excel 2010 Format cells to use as Gantt or Plan	Kizzie	Excel	0	12-13-2011 02:31 AM
password protect excel file?	Dawg751	Excel	2	01-28-2010 06:23 AM
Importing individual cells from Excel to Word	themangoagent	Word	1	10-12-2009 08:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 AM.