Hyperlink

[Excelboo2]

I have a spreadsheet in JPG imported in a sheet. And I have some figures in other sheets (in excel) that I want to make reference to that JPG worksheet. Is is possible to do that? (ie if that JPG was just a ordinay excel worksheet, I could just use hyperlink). Many Thanks

 

[ango858]

I have a spreadsheet in JPG imported in a sheet. And I have some figures in other sheets (in excel) that I want to make reference to that JPG worksheet. Is is possible to do that? (ie if that JPG was just a ordinay excel worksheet, I could just use hyperlink). Many Thanks

If you just need to be able to open and close the jpg as needed through excel you could write a macro that can call the file.

for instance:

sub grabjpg()
dim filepath as string
dim jpgfile as string

'file path of folder that jpg is located (change as needed)
filepath = "C:\My documents\My pictures\"

'name of file needed (change as needed)
jpgfile = "Report.jpg"

workbooks.open filepath & jpgfile

End sub

and just copy this into a module and assign a button to it

*sorry if im not understanding your question