protect shape from editing

Anonymous
2014-02-04T07:16:06+00:00

I want to protect shape for my macro enable workbook

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

6 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-02-04T07:49:38+00:00

    Protect your sheet. It will protect objects/shapes also.

    In case you don't want to protect cells, but only objects then select the whole sheet and go to format cells/protection/uncheck lock cells.

    Then protect the sheet. Now it will allow entry in cells but protect the objects/shapes.

    Hope it helps.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-02-04T09:30:50+00:00

    Thanks, but tell if it is helpful in macro enabled sheet Here the link-

    http://sdrv.ms/LKuBil

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-02-04T09:40:58+00:00

    It will not make any difference whether your sheet is macro enabled or not. It should work.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-02-04T12:37:45+00:00

    when i try to print sheet then 'application defined or object defined error took place'

    when the sheet is protected some cells are not protected in LC sheet, please reply.

    Was this answer helpful?

    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more