R
robzrob
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
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