Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? -- Thanks, Howard |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting a picture into unprotected cells in a protected excelworksheet | Excel Worksheet Functions | |||
How can I import a picture on a protected worksheet | Excel Worksheet Functions | |||
protect a worksheet from inserting a picture | Excel Discussion (Misc queries) | |||
how can I add a picture into protected worksheet? | Excel Worksheet Functions | |||
Inserting Picture in protected sheet | Excel Discussion (Misc queries) |