LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Ola
 
Posts: n/a
Default

Well there is another way...

Use the old, hidden and almost forgotten "Camera button" !

Here is how to add the Camera Icon Button:
Menu:Tools, Customize, Commands(tab)
Click on Categories: Tools.
70% down there is a small Camera button.
Drag and drop to your icon menu bar.

Next here is an Example how to use your new Camera button to create a
Dynamic Picture link. I hope you can follow:

1. Insert a red Circle (autoshape) and place it over cell D1.
2. Insert a green Circle and place it over cell E1.
2. Mark the cell where your red circle is located (D1)
3. Now Click the camera and paste where you want your 'picture' to be placed.
4. Click on your picture. The formula bar will show the cell reference
=$D$1. Delete that reference and write instead =Circles
6. Next go to the Menu: Insert, Name... Define and insert a name called
Circles and use the formula =IF(A1=1,D1,E1). This will focus the picture on
either the Red Circle or the Green Circle.
7. Try to change the value in A1 and you will see that you picture will show
a red or a green circle.

This is the principle.
Have fun

Ola Sandstrom

 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
ms excel IF statement w/pictures? Scott Links and Linking in Excel 4 March 1st 05 09:54 AM
MS Excel IF Statement w/pictures? Scott Excel Discussion (Misc queries) 4 February 17th 05 03:05 PM
Excel Report Using IF Statement? Marc Excel Discussion (Misc queries) 3 January 11th 05 07:38 AM
SQL Statement and Excel DavidM Charts and Charting in Excel 3 January 7th 05 12:53 PM


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