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?

Ive done this in Word, using bookmarks. I dont 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.

Im 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 he
http://www.vexentricity.com/?p=77

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

Good luck,
Ryan---







"Scoop" wrote:

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?