Hello
Not sure if this can be done. Anyway...
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
Not sure if this can be done. Anyway...
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