Susanna has attended:
Excel VBA Intro Intermediate course
Taking Minutes course
Excel VBA Advanced course
Excel PowerPivot course
Paste image in unprotected cells of protected sheet
I have an Excel file with a protected sheet (by password) which contains locked and unlocked cells. I need to allow users to paste an image (copy from another file, paste in the excel sheet) in some unprotected cells of the protected sheet, but I get the error: "You cannot use this command on a protected sheet".
Do you have any solution? Thanks!
RE: Paste image in unprotected cells of protected sheet
Hi Susanna
Interesting question! Normally you can't paste a picture into a protected sheet.
However you can if you tick the option 'Edit Objects' in the list Allow all users of this worksheet to...
First Unprotect the worksheet then tick Edit Objects before protecting the sheet with the password.
Hope that still helps. The option allows pasting of pictures and other graphical objects in any cell of the worksheet, not just the unlocked cells.
Regards
Doug Dunn
Best STL
