Forum Discussion

Alfred_Vienneau_'s avatar
Alfred_Vienneau_
Copper Contributor
Mar 27, 2022

Posting a picture in Word Excel on a protected sheet

I need to paste pictures on a Word Excel Protected Sheet.  I know I can unprotect it and paste the picture, then protect it, but even if I unprotect several slots, once the sheet is on the protected mode, I cannot past the picture in the unprotected slots.  Is there a way to do it without unprotecting the sheet?  This is used as a Goal Sheet.  I would like someone to paste pictures of their goals on the protected sheet.

 

 

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Alfred_Vienneau_ 

    Please understand that in this world there are many different versions of Excel and Word for different operating systems.

    That is why it is important to have the information as basic data in advance.

    At the same time, the possibilities in Office are so many that some are inclined to say "as sand in the sea".

    That's why I insist on such information in advance.

    In your case (as far as I understand) you cannot insert an image from Word into Excel because the Excel worksheet is locked.

    When the worksheet is locked, you cannot insert an image or anything else into the worksheet.

    You need to unlock the worksheet first. If you don't have the password for it, you could try these links (where you can find information about how to unlock).

    Password Options

    How to unprotect the excel sheet if forgot the password

     

    Hope I was able to help you with this information :).

     

    NikolinoDE

    I know I don't know anything (Socrates)

    • Alfred_Vienneau_'s avatar
      Alfred_Vienneau_
      Copper Contributor
      My Son in Law is a whiz in computers and once again, he's shown me how to do it. Yes I can set it up to lock the page and install pictures on the page. Problem solved. When I'm on the process of protecting the sheet, I just need to unselect locked cells and then select "Edit Objects" and it works.
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Alfred_Vienneau_ 

    Many questions arise, Word or Excel? from where to where? Who is banned and who is not?...

    With your permission, if I may recommend, add a file (without sensitive data) and use this file to describe your problem step by step, or add photos with the appropriate description.  

    (Drag and drop here or browse files to attach
    Maximum size: 71 MB • Maximum attachments allowed: 5)

    You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

    Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc. :).

     

    Don't forget no one in this forum can see what you see.

    In this link you will find some more information about it:

    Welcome to your Excel discussion space!

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources