LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default INSERTING A PICTURE ON WORKSHEET

A possible non-VBA solution:

I'll assume you want the pictures to show on Sheet1.

1)Paste a picture into a blank sheet in your workbook.
2)Select the range of cells that contains the picture,
3)Set the fill color of the range to White.
4)Name that range of cells:
Example:
InsertNameDefine
Name: Farming

5)Repeat steps 1 thru 4 for each picture (making sure that no picture ranges
overlap)

6)Select Sheet1 and type one of your picture range names in Cell A1.
7)Create a dynamic range name as follows:
InsertNameDefine
Name: ShowMyPic
RefersTo: =INDIRECT(Sheet1!$A$1)

8)Select cells A5:B10.
9)Hold down the [Shift] key and EditCopyPicture
10)Paste the picture somewhere over Cell E10.
11)While the picture is still selected, type this in the formula bar:
=ShowMyPic
then press [Enter]

The range of cells that was previously displayed should now be replaced by
the picture referred to by the name you typed in Cell A1.

Each time you type a different picture range name in Cell A1 the associated
picture will appear in the picture box and resize appropriately.

Also, you could reference a list of those picture range names in a Data
Validation for Cell A1 so you could simply pick them from the list.

Is that something you can work with?

Regards,
Ron
 
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 Picture Into Protected Worksheet YankeeFan Excel Discussion (Misc queries) 1 March 17th 10 06:51 PM
Inserting a Picture using Cell as picture name. the-jackal Links and Linking in Excel 12 November 10th 08 09:21 AM
protect a worksheet from inserting a picture daves Excel Discussion (Misc queries) 0 June 22nd 06 07:31 PM
Inserting Picture LMB New Users to Excel 1 October 2nd 05 11:02 PM
get a picture width and height without inserting the picture Dorothy Excel Programming 1 January 13th 05 05:06 AM


All times are GMT +1. The time now is 12:07 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"