ExcelBanter - Worksheet Protection and Inserting Pictures

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Worksheet Protection and Inserting Pictures (https://www.excelbanter.com/excel-discussion-misc-queries/11366-worksheet-protection-inserting-pictures.html)

Hood

Worksheet Protection and Inserting Pictures

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?

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

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?

All times are GMT +1. The time now is 06:49 PM.