Display a Sheet as an image object in a Workbook - Solved

[vijay.mudivedu]

Hi,

I am trying a few things that would embed a sheet as an object in a workbook.

Problem scenario:
I have an excel Workbook1.xlsm which has Sheet1, Sheet2, Sheet3, Sheet4.

Sheet 3 - has a few Graphs.

In Sheet1, I am trying the embed and display the Graphs of Sheet3 as a clickable image object. The image I am trying to show is a replica of Sheet3.

So when I click on Image, the action will open the the Sheet3 and displays the Graphs in Sheet3.

My Approach

1. I tried insert--> Hyperlink, link the Sheet3. This action gives me option to Navigate to Sheet3. But, it doesn't display Sheet3 as an image.
2. To display workbook as an Image,
   1. I tried Insert-->Object --> Create From File --> "Select Current Workbook1". But I cannot insert opened file in the selected workbook. This is hindering.
   2. Inserting another workbook and change the path to the current workbook, but this option of changing the path is not working.

Am I missing something?
What are the alternate ways of doing this?

Seniors, if you can provide this information on embeding a sheet as in image in the current workbook, it would be of great help.

Thanks,
Vijay

 

[Hui]

Vijay

Firstly, Welcome to the Chandoo.org Forum

What about using the Camera Tool?
Refer: http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/

You will need to add some VBA so that when you click on it it takes yo to the other worksheet

If your post your file here I ma sure we can assist you

 

[vijay.mudivedu]

Thank you Sir!! Really pleased with your answer, promptiveness, effectiveness. You guys are really awesome and Excel too is!!

Been struggling for 2 days. You made my day!!