I'm pretty sure this can not be done with just protection, you would have to
create a macro that would unprotect the sheet then reprotect it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Paul Kouri" wrote:

I have created a worksheet with protected and unprotected cells. I have
created a area C2:J10 as an area for the user to post a picture. However
when the worksheet is protected the option is grayed out. Is there a way to
insert a photo into a protected sheet? I've spent hours researching the help
text as well as microsoft forums and can't find a similar instance.
Paul