I need to protect a worksheet (with password) and still allow user to insert
Picture (from file only, if that helps), how can I accomplish this?

Hood

Unprotect, insert, reprotect.

Sub Macro1()
ActiveSheet.Unprotect Password:="justme"
ActiveSheet.Pictures.Insert ("E:\Winter.jpg")
ActiveSheet.Protect Password:="justme"
End Sub


Gord Dibben Excel MVP

On Thu, 3 Feb 2005 06:25:03 -0800, "Hood"
wrote:

I need to protect a worksheet (with password) and still allow user to insert
Picture (from file only, if that helps), how can I accomplish this?