Cells can only contain values or formulae. Photos exist in the drawing
layer 'above' the cell layer.

When you protect your sheet, uncheck the "Objects" checkbox in the
Protect Worksheet dialog.

Note that the user can then paste the picture anywhere, not just in the
vicinity of the desired cell.


In article ,
Perp wrote:

Once protected text can only be entered into the unlocked cells, as
expected. Now the rub. I would like them to be able to enter photos into an
unlocked cell, but cannot figure out how to do it, unless the sheet is
unprotected.