Protecting a Graphic

Larry asked if there was a way to protect a graphic inserted in a worksheet or the header or footer of a worksheet so that it cannot be removed. The answer (as with many things in Excel) is both yes and no.

If you place a graphic in a worksheet, then when you protect the worksheet the graphic is also protected. In fact, once worksheet is protected, you cannot even select any graphics in the worksheet, which is a prerequisite to them being deleted.

On the flip side of the coin, there is no way to protect graphics placed in headers or footers. Even if you protect the worksheet, the header and footer can still be changed, and thus the graphic can be selected and deleted.