If I remember right, before you can manipulate locking and unlocking
cells, your sheet has to be unprotected. So, to do what you describe,
you'd have to unprotect the sheet, lock the cell, then protect the
sheet.


Hugo wrote:
> I have set up a sheet with some protected and unprotected cells. I then
> created a macro to protect cells after user makes an entry. The macro works
> ok at this point. I then protect the sheet and the macro does not work.
> It gives me error 1004.
> I am using ActiveCell.Locked = True and I have tried various combinations
> with other functions.
> I have also allowed macros to run.