Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link to cell from PowerPoint
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link text box in powerpoint to a cell | New Users to Excel | |||
Link Excel Workbook to Powerpoint | Excel Worksheet Functions | |||
PivotChart Link to PowerPoint | Charts and Charting in Excel | |||
Link to powerpoint resizing graphs | Excel Worksheet Functions | |||
Excel link to powerpoint | Excel Discussion (Misc queries) |