I have pictures of several products. I have to link each picture with an Excel sheet in such a way that when I click on the picture, it will open the right Excel sheet. How can I do this?

yes these pictures are in my computer. these pictures are picture of the procducts and the person want to open the price bar of the products in the excel sheet when he click on the picture of the product. the excel sheet is complete. I have tried but could'nt find a solution. you some solution please. maybe have to upload them on a website first?

First the set the Name of each picture to the Name of the desired destination sheet. (so we have a Picture or Shape named "dog" and a worksheet also named "dog")

Then assign this macro to all Pictures:

Sub ClickMe()

    Sheets(ActiveSheet.Shapes(Application.Caller).Name).Activate

End Sub

EDIT#1:

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window


2. ALT-I
   ALT-M opens a fresh module


3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.
If you are using a version of Excel later then 2003, you must save
the file as .xlsm rather than .xlsx

To remove the macro:

1. bring up the VBE window as above


2. clear the code out


3. close the VBE window

To use the macro from the Excel window:

1. Click the associated Picture or Shape

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

and

http://msdn.microsoft.com/en-us/library/ee814735(v=office.14).aspx

Macros must be enabled for this to work!

Insert Picture Into Cell:

1. Insert tab (on ribbon), Illustrations section, Pictures -> opens dialogue, Select image.


2. Size the image small enough and the cell large enough that the image fits within the cell.


3. Lock the image into the cell: Right click image, Size and Properties ... -> opens dialogue, Properties Section (expand if closed by clicking Properties), select Move and size with cells (& Print as desired).

Link Cell To a Sheet in this Workbook:

1. Right Click Image in cell, Select Link, Dialogue opens.


2. In the "Link to:" section, Select "Place in This Document".


3. Modify the cell reference as desired.


4. Select "ScreenTip..." and enter the mouse over text if desired. Click OK


5. Click OK.

Alternate: Entire cell as clickable link (not just image).

1. Follow steps for placing an image in a spreadsheet cell (someplace out of the way).


2. Copy this cell (not the image). Select the cell with the arrow keys instead of the mouse may be easier, then press Ctrl-c to copy.


3. Right click the cell for the link, Paste Special..., Other Paste Options section (at bottom), clipboard on right with links (there are two like this), Select the one with screentip or label "Linked Picture" (not "Paste Link").


4. Complete Step 3 of "Insert Picture Into Cell - Lock the image into the cell"


5. Complete all steps of "Link Cell To a Sheet in this Workbook". Note for step 1: Right Click the Cell (since the entire cell is one with the image - source: Yoda).

User Scenario: Clicking Windows Desktop Pic to Open Excel

Specifically, an Excel Workbook's Worksheet and Cell associated with the product in the icon image.

Assumes the user will be clicking an icon of a product image, either on the desktop or in some other folder.
Previous answers assumed the images were in the cells of a worksheet inside an Excel workbook.

Here is the solution:

With createobject("Excel.Application")

    .Goto .Workbooks.Open(WScript.Arguments.Named.Item("book")). _

        Worksheets(WScript.Arguments.Named.Item("sheet")). _

        Range(WScript.Arguments.Named.Item("range"))

    .visible = True

End With

• Save the code to a file named ExcelShortcuts.vba and be sure the file has the ".vba" extension.


• Create a shortcut to this file. (quick tip, drag the file icon and hold the Alt before and while releasing the left mouse button.)


• Rename the shortcut Product_1_Name, whatever that may be (no filename extension needed).


• Right click the Product_1_Name file shortcut icon and select Properties.


• In the Properties dialogue, select the Shortcut tab and make these two changes:
  
  
  
  
  1. In the Target text box, at the end after ...ExcelShortcuts.vba (and after any closing quote):
     
     
     
     
     • Add a space and /book:"C:UsersnameDesktopProductWorkbook.xlsx" /sheet:Sheet1 /range:A1
       
     
     
     • 
       /book:FilePathFileName Replace the file path and name as appropriate for the product
     
     
     • 
       /sheet:Sheet1 Change Sheet1 to the sheet name for the product. If the Sheet Name has spaces, use quotes starting right after the :. /sheet:"Quote Special Chars ! too"
       
     
     
     • 
       /range:A1 Change the A1 to the cell address to focus on.
     
     
     
     
  
  
  2. Click Change Icon...
     
     
     
     
     • Navigate to the folder (Browse) with the product pictures and select the image for this product.
     
     
     • Click OK
       
     
     
     
     
  
  
  
  


• Click OK

Now there is a shortcut with the product image on it. The shortcut is to the special VBSCript which will open Excel. The script will use the arguments supplied to the shortcut to know which Workbook to open and which Worksheet to turn to and which cell to focus on.

Make more shortcuts to the ExcelShortcuts.vba script. Rename each one to a product name. Modify the shortcuts Target (add /book: /sheet: /range:) and change the icon image to one which represents the product.