Category "cell"

disable editing in cells without protecting worksheet vba

I want to disable cell editing (direct typing into cell) but want to update that cell through code without protecting worksheet Does anyone have any idea?

Run macro automatically when cell value changed (not changed by user)

Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th