Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default How to link PP shape to individual sheet in a workbook?

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.

--
when u change the way u look @ things, the things u look at change.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Individual sheet protection in shared workbook Sunil Pradhan[_2_] Excel Worksheet Functions 1 May 16th 10 03:51 AM
how do I link to another sheet in workbook? Pmsrefugee Excel Discussion (Misc queries) 12 February 25th 10 04:49 AM
separate Undo for each individual sheet in a workbook? wildetudor Charts and Charting in Excel 0 January 21st 09 10:22 AM
Link individual sheet to one sheet in another workbook dfield Excel Discussion (Misc queries) 1 March 12th 06 02:26 AM
how do i link from one sheet to another in the same workbook? savita Excel Worksheet Functions 1 March 9th 06 04:31 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"