Forum Discussion
How do you protect images from being moved in a protected worksheet
- Apr 01, 2019
Hi,
Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.
Hope that helps
Hi,
Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.
Hope that helps
Thanks for the reply. As it turns out, the lock was checked on all my images already. I finally figured out that when protecting the worksheet, examine the actions you will allow after it is protected. Before entering a password, scroll to the very bottom and make sure the check is removed from "edit objects". Funny how I have read about 30 responses on how to protect those images, but none of them bother to explain the nuances of the protect worksheet function. I also found that headers and footers are not protected by worksheet protection methods.
- Haytham AmairahApr 02, 2019Silver Contributor