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.