You can unprotect it and then protect it again within your code.

ActiveSheet.Protect Password:="fish"

'your code to insert picture, will be something like this but you may also
want to resize or reposition it

ActiveSheet.Pictures.Insert("C:\mypic.jpg")

ActiveSheet.Unprotect Password:="fish"


if screen flickering is a problem, use
application.screenupdating = false before your code AND
application.screenupdating = true after it

HTH
--
Allllen


"ZipCurs" wrote:

I would like to insert a picture from file into a protected worksheet. At
this point, the Excel pull down menus are greyed out for this feature as long
as the sheet is protected. As far as the user is concered, I want to keep
the sheet protected.

I am looking for a simple solution to allow the insertion of a picture. If
this does not work, I will most likely resort to creating a macro with a
button for picture insertion.

Thanks for the help in advance.