Try the following code, which needs to be placed in the code module for the sheet (right-click the sheet tab, and select 'View Code')...
If the worksheet is protected without a password, replace...
with
Also, the merged cells do not need to be Locked in order to insert a picture. So if the user only needs to insert a picture and doesn't need to enter any data within the merged cells, they can be left Locked and the following lines of code can be deleted...
Note that in a protected worksheet "Edit Objects" needs to be checked in order to allow users to insert a picture.
Hope this helps!
Bookmarks