How to link PP shape to individual sheet in a workbook?

S

sahafi

Let's modify this:

How can I link my PP shapes (in my PP Org Chart) to individual Excel sheets?
I can do that with Word, but using Excel, it will basically open any sheet in
the workbook, and I have about 45 worksheets. Is there any VBA code that I
can include to force the hyperlink to open up needed sheet?

Thanks.




I have an existing Org chart of 45 employees with their pictures and titles
on PP.
I would like to add more details for each employee via hyperlinks. I have
created an Excel workbook with 45 sheets named after the employees. I would
like for the user to be able to click on the person name or title, and have a
new small window open up with that employee's details from Excel. What's the
best approach to accomplish this?

Any direction is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top