Link to cell from PowerPoint

[Scoop]

I figured out that I can create a link in a PP presentation that jumps
right to a cell in a worksheet like so:

Link= <filename>.xls#<sheetname>!<cellreference>

It works great but I ended up having to created dozens of links like
this.

I was wondering if there is a way to write a function that is run when
the workbook is opened that can trap the "bookmark" (everything after
the '#'), find the cell with a matching value, and jump to that cell.
That way, I could just pass a value to look for in the link as opposed
to hard-coding the cell reference over and over.

Any ideas?

 

[ryguy7272]

I’ve done this in Word, using bookmarks. I don’t think PowerPoint uses
bookmarks though, right. Maybe you can insert a Hyperlink in your .ppt file
and link that to an Excel cell. Values should update automatically.

I’m not sure how Excel, or PowerPoint for that matter, would ‘know’ how to
sync Excel values and Hyperlinks, or bookmarks, or whatever, in PowerPoint.
Maybe a Sub would do it; pretty sure a Function would not do it.

Look here:
http://www.vexentricity.com/?p=77

This may help too:
http://peltiertech.com/Excel/XL_PPT.html

Good luck,
Ryan---