View Single Post
 
Old 04-04-2012, 04:15 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

Quote:
Originally Posted by davesexcel View Post
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.
Reply With Quote