I have approx 20 Boxes in a hierarchical Structure chart. I want each box to be a snapshot of the corresponding worksheet in the workbook. I know how to HYPERLINK the Text...I want a small OBJECT BOX that links to the WORKSHEET. I have been able to make the file link to the worksheet I am on, but when I try to direct it to the correct sheet for that chart box I get and error: =Excel.sheet8|'Group Project Diagrams.xls'!'Context Diagram'
I think it's my syntax...any suggestions
thanks,
Brad
I think it's my syntax...any suggestions
thanks,
Brad