Hi All,
I hope you are well.
I have a spreadsheet that I require the user to insert their photo in. However, I also have other images on the sheet that need to be protected.
Is there anyway to have the worksheet protected to prevent edit/deletion of objects (i.e. the other images) but at the same time allow users to insert an image (i.e. their photo)?
The problem I am having is that with worksheet protection and edit object ticked, the file lets users insert image, but also allows them to delete other images which I don't want. The apposite problem occurs (i.e. user can't edit /delete but can't also insert) when the edit object is unticked.
Is there anyway around this?
Thanks in advance for all your help guys.
Bookmarks