Excel VBA: Worksheet_Change Cells.Protect

tinfanide · #3 04-04-2012, 04:15 AM

Quote:

Originally Posted by davesexcel

You would have to unlock all the cells first, and then lock the cells you want protected before you protect the sheet.

Well, nothing to do with Cells.Locked = False (I guess this is what you meant) in the above file. Please kindly open the file and see. I've used

Code:

Application.EnableEvents = False
Application.Undo
Application.EnableEvents = True

to protect the column to be protected. But it stops working when I try to delete the cell in that column.

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