Having tried to protect a cell that has a formula and
also having a comment attached to the cell saying "If you
want to type in this cell go to Sheet1 cell..Etc and type
there..." Does anyone know some code so that...

If someone tries to type in a cell then it produces a pop
up message?