Inserting Picture Into Protected Worksheet
First of all, you cannot insert a piture "into" a cell.
Just lay it on top.
Second............if you allow users to Edit Objects when protecting sheet,
you can insertobjectbitmap image.
Paint will open with a picture frame...............EditPaste From
Browse to the picture(any type, jpg is good) and double-click or Open
Will be pasted into the Paint Frame and be inserted in Excel sheet.
Gord Dibben MS Excel MVP
On Wed, 17 Mar 2010 09:05:02 -0700, YankeeFan
wrote:
Is this possible? At work, we use Excel 2003. I have about ½ dozen cells,
with formulas locked, but the rest of the worksheet is unlocked. When I go
to Protect the sheet, I can no longer insert a picture. Can I do both,
protect a formula from being deleted or altered but still be able to insert a
pic into a large cell?
|