Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    MN
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink to Excel and back (XP)

    I'm doing the presentation that hyperlinks to an Excel spreadsheet. I need to go back and forth between the presentation and the spreadsheet. Two questions:

    How do I do a PPT hyperlink to a specific worksheet/cell in the Excel spreadsheet? I can get the first worksheet OK but as the presentation goes on I want to got to the subsequent sheets.

    Once in Excel is Alt-Esc from the keyboard the only way to get back to the slideshow (in presentation view) or is there a way to setup a hyperlink that would take me back to the slide I was on in presentation view?

    Thanks!

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Hyperlink to Excel and back (XP)

    A few thoughts.

    First, I've never used Alt-Esc before. Thanks for that. I use Alt+Tab to switch among running applications. It doesn't minimize anything, just flips among the applications. (Holding Alt and pressing Tab once, you get an icon bar that sometimes helps in finding your way back.)

    Second, I can't imagine a "safe" way to hyperlink back to a running presentation and expect to be on a page other than the first. Why? I understand a hyperlink (other than an internal one to the same page) to be something like double-clicking the document in Windows Explorer: a launch command. Maybe I'm wrong about this.

    Third, it should be possible to write a macro in Excel (using some Windows API calls) that would find the presentation running in memory and return that window to the front of the windows "z-order." You then could assign that to a button or keystroke to return to your presentation as though you had used Alt+Tab. But I'm not sure that's worth the effort.

    Alternatively, you could add some code to do a cool "shrink to center and vanish" (actually, it would minimize) effect on your Excel window. That might be worth the efffort. Your creative options really are unlimited here, except for the minimum window size. Unlike the animations built in to PPT, however, you or your favorite VBA author would have to do a little math and a lot of testing to make sure it works correctly. Also, there is a risk that the next time you hyperlink to Excel, it would be a tiny dot rather than a normal window.

    Fourth, if you use VBA code in PPT, rather than a link, for subsequent visits to your Excel workbook, you could control the tab that is displayed. I'm not sure there is a way to do this with a hyperlink.

    Have fun!

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    MN
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Excel and back (XP)

    Guess I'll just stick with the Alt-Esc method. The cure appears to be more painful than the disease <G>. Thanks for the input. RJ

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Hyperlink to Excel and back (XP)

    How do I do a PPT hyperlink to a specific worksheet/cell in the Excel spreadsheet? I can get the first worksheet OK but as the presentation goes on I want to got to the subsequent sheets.

    Try copying the cell/s from Excel and using the Paste as Hyperlink choice under the Edit menu. (note: for best results, make sure there is something inside the Excel cells.
    If you want to create a button or other graphic that is linked to the location you can edit the hyperlink by adding:
    <font color=blue>yourexcelfilename.xls#sheetname!cellref erence</font color=blue>

    Once in Excel is Alt-Esc from the keyboard the only way to get back to the slideshow (in presentation view) or is there a way to setup a hyperlink that would take me back to the slide I was on in presentation view?

    Don't forget that if you minimize Excel, your Presentation will be running behind it - you'll be in the slide you left from.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Hyperlink to Excel and back (XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Catharine

    <font color=blue><<< If you want to create a button or other graphic that is linked to the location you can edit the hyperlink by adding:
    yourexcelfilename.xls#sheetname!cellreference >>> </font color=blue>

    OK, how about going to a code module in the VBE, in MS-Excel, from a displayed PowerPoint slide? Is there a reference to the VBE?

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •