Share via

Inserting Object in a Protected Sheet

Anonymous
2014-06-11T12:56:06+00:00

Hi,

I have an Excel 2013 sheet which I have password protected except for one cell in which I would like the user to insert an object.

But when I am testing it I get a message saying "Cannot insert object".

Can someone please help me understand how this can be resolved.

Appreciate your support in advance.

Regards,

Sachin

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2014-06-11T13:18:43+00:00

    Insert Object is not a cell level property but a sheet level property. Hence, unlocking cell will not solve the problem.

    When you protect your sheet, choose Edit Objects also. It will allow you to insert objects in the sheet (not only to that specific cell)

    15 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-26T09:12:43+00:00

    Hi , I faced a problem when check on edit objects and save the file . After unprotect the file , the edit objects will unchecked automatically. 

    I discover only happened in format xlsx instead of xls. 

    Any one can help about this ?

    Thanks.

    0 comments
  2. Anonymous
    2015-08-26T20:01:17+00:00

    I know this is an old thread but did you happen to figure this out?  I'm having the same problem.

    1 person found this answer helpful.
    0 comments