Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Inserting Picture Into Protected Worksheet

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting a picture into unprotected cells in a protected excelworksheet Joel Buhler Excel Worksheet Functions 0 December 31st 09 03:36 AM
How can I import a picture on a protected worksheet Terry Excel Worksheet Functions 0 June 17th 08 05:06 PM
protect a worksheet from inserting a picture daves Excel Discussion (Misc queries) 0 June 22nd 06 07:31 PM
how can I add a picture into protected worksheet? Chusena Excel Worksheet Functions 1 April 22nd 06 06:44 PM
Inserting Picture in protected sheet JackR Excel Discussion (Misc queries) 6 February 19th 06 10:11 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"