ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Image Link (https://www.excelbanter.com/excel-discussion-misc-queries/218158-image-link.html)

mm

Image Link
 
How to create image link from one sheet to another in excel?

Chip Pearson

Image Link
 
It depends on what you mean by an "image link". If you have an image
file that you want to use, go to the Insert menu, choose Picture then
From File. Navigate to and open the desired image. Then, open the VBA
editor, insert a new module (Insert menu, Module), and enter the
following code:

Sub GoToCell()
Application.Goto Worksheets("Sheet2").Range("C10"),True
End Sub

Then go back to Excel, right-click the picture, and choose Assign
Macro and then pick GoToCell from the list. Now, when you click the
picture, GoToCell will be executed, and you will be taken to
Sheet2!C10.

If this is not what you want, provide much more detail.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Wed, 28 Jan 2009 04:40:06 -0800, MM
wrote:

How to create image link from one sheet to another in excel?



All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com