Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Shortcut: Open Worksheet Object (97)

    Is there a shortcut for Open Worksheet Object?

    If there is not, is there a way to assign a shortcut to this?

    Thanks!

  2. #2
    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: Shortcut: Open Worksheet Object (97)

    In VBA? Or are you trying to find a fast way to launch a presentation?

    If so, save your presentation as a powerpoint "show". You can create a shortcut to the show from your desktop to quickly and smoothly start the presentation.

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

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    Here is a better clarification of what I am trying to do..

    Most of our powerpoint presentations aren't presentations, but printed out pages of financial info. So I mainly use excel spreadsheets in my ppts. I am constantly right clicking and then choosing 'Open Worksheet Object'.

    I am wondering if there is a keyboard shortcut that will open the worksheet object...

  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: Shortcut: Open Worksheet Object (97)

    Try right clicking on the object (when building the presentation - not at delivery time) and choosing Action Settings (see dialog box).
    You can hyperlink to the excel file and choosing whether a click or mouse over will launch it.

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

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    I'm really not explaning myself well here!

    What I am attempting to do is to find a shortcut to 'Open Worksheet Object' while creating a presentation.

    So while I am creating the presentation I can just select the worksheet object and type the shortcut.

    These presentations are actually never ran on the computer, just printed out...

  6. #6
    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: Shortcut: Open Worksheet Object (97)

    Okay - I'm puzzled - Is this for printing or an onscreen presentation PPT?

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

  7. #7
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    I'll try clarifying again (thank's for being patient Catharine)

    While creating presentations (printed or on-screen) I would like to try and find a shortcut for working on my excel spreadsheets which are in my powerpoint presentations.

    Rather than having to click three times (in ppt 2000) to 'open worksheet object' I would like to select the worksheet object and then have a keyboard shortcut to 'open worksheet object' so that I may make whatever changes I need to make.

    I think the key point here is that I am looking for a shortcut while I am creating the presentation, not while presenting the presentation... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    ...and how about a bit more clarification:

    You say you currently click three times to 'open worksheet object'. Which three clicks? I can't find 'open worksheet object' in PPT.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    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: Shortcut: Open Worksheet Object (97)

    "I think the key point here is that I am looking for a shortcut while I am creating the presentation, not while presenting the presentation"

    Aaaahhh! Okay - now I understand <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15>. And now this is the part where I tell you that this probably requires a VBA answer <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    I've taken the liberty of posting a request for a solution on the VBA board. The moderators there will lock the thread so that answers don't get posted on two boards.

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

  10. #10
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Shortcut: Open Worksheet Object (97)

    The three clicks are on the worksheet object itself - first click selects the worksheet object, then doubleclicking makes it available for editing (same as select worksheet object > right-click > Edit).

    Not too optimistic about finding a shortcut or command though....

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    Gary,

    Ok, I get it. I was looking for a keybindings object, but don't see one in PPT 2002.

    I'll side with you. Not a bright prospect.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  12. #12
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Shortcut: Open Worksheet Object (97)

    Hi again,

    The following code seems to do the trick:

    <pre>Public Sub EditExcelObject()
    With ActivePresentation.Slides(1).Shapes(1).OLEFormat
    If .ProgID = "Excel.Sheet.8" Then
    .Activate
    End If
    End With
    End Sub
    </pre>

    - this assumes that the Excel object is the first shape on the first slide - this could be modified to be more flexible for instance if you have more than one Excel object in your presentation.

    -I'm working in PPT 2000 and Excel 2000 so am a bit surprised that it identifies the embedded Excel object as "8" - hmm...

    You could store this macro in a code module behind your presentation, and presumably assign a keyboard shortcut for running it.

    Gary

  13. #13
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Shortcut: Open Worksheet Object (97)

    Hi Kevin,

    See the code attempt just posted.
    Subsequently I looked for a way to assign a key shortcut in the PPT interface, but didn't see it - betraying my lack of knowhow in PPT - perhaps there is no way to assign key shortcuts in PPT(?!)

    An alternative might be to link the macro to a toolbar item and assign a hotkey combination to trigger it.

    Gary

  14. #14
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    And not to be outdone by the respectable, affable and
    insightful Mr. Frieder, I offer this amendment that loops till it
    finds the first Worksheet:


    <pre>Public Sub EditExcelObject()
    Dim sld As Slide
    Dim sh As Shape
    For Each sld In ActivePresentation.Slides
    For Each sh In sld.Shapes
    If sh.Type = msoEmbeddedOLEObject Then
    If sh.OLEFormat.ProgID = "Excel.Sheet.8" Then
    sh.OLEFormat.Activate
    exit sub
    End If
    End If
    Next
    Next
    End Sub
    </pre>


    Still no success in figuring out how to put a short-cut key on a
    macro. Very strange.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  15. #15
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Shortcut: Open Worksheet Object (97)

    I think I'll give up about here then! <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    Thank's everyone for their help..

Page 1 of 2 12 LastLast

Posting Permissions

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