Inserting Picture Into Protected Worksheet

Y

YankeeFan

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?
 
G

Gord Dibben

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 insert>object>bitmap image.

Paint will open with a picture frame...............Edit>Paste 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fit text in linked cells of a protected worksheet 1
Place picture in Excel cell 0
Import data into protected worksheet 0
How to change format protection default to unlocked? 2
Protecting Worksheet - Cannot move between cells. 2
hide columns on a protected sheet??? 1
corrupted formula in protected worksheet 21
Can't move between cells. (Not the scroll lock) 1

Top