Sunday, October 4, 2009

Prevent object from being selected

Let say you have an Excel worksheet which has an embedded signature image of which you don't want it to be selectable:
- Select whole worksheet > right-click > Format Cells > Locked=No
- Format the image you want to protect with Locked=Yes
- Tools > Protection > Protect Sheet
- uncheck "Select locked cells" and check "Select unlocked cells"
- assign password to unprotect

No comments:

Post a Comment