Worksheet Protection and Inserting Pictures

H

Hood

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

Gord Dibben

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
 
Top