is there a way to lock certain cells for editing through a piece of VBA code?
i have some data in cells D1:D100. i would like to prevent people from editing those cells, it could pop-up a message "cannot edit" or something like that.
i tried using Target.AllowEdit = False in the SelectionChange event, it does not work. i do not want to use Protect Sheet from the Tools menu for some reasons.
thanks in advance for any inputs,