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?
|