View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robzrob@hotmail.com is offline
external usenet poster
 
Posts: 5
Default Link certain cells to 2 photos each

Hello

Some cells in col I of 1st worksheet contain numbers like this: 4063887. For each number in col I there are 2 photos, so, for example, for this number I have photos with filenames:

2012-04-12-CN4063887-1 and
2012-04-12-CN4063887-2

I'd like to be able to select cell 4063887 and then have one keystroke to go to/show 2012-04-12-CN4063887-1 (F1?) and another keystroke (F2?) to go to/show 2012-04-12-CN4063887-2.

I want to keep the photos in the workbook somewhere and also want to be able to put them in the workbook as and when I get them as easily and quickly as possible! (I notice that when I insert a photo into any worksheet in the workbook the filename shows in the Alt Text part of the photo's Properties.)

Cheers
Rob