Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Select worksheet on open macro

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Haydn Cooper
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    As I had no response to the last call for help, am trying a different tack. Am now trying to build a macro that will open an Excel workbook with 3 worksheets on a particular worksheet - "Presentation", select an object, double-click the object so that it opens in Powerpoint Slideshow? (I have copied and paste-linked all the powerpoint slides into my sheet so that it will do this).

    What I have so far is :
    Sub Auto_Open()
    Sheets("Presentation").Select
    ActiveSheet.Shapes("Object 22").Select
    Selection.Verb
    End Sub

    The object is being selected but I can't get it to doubleclick not open in SlideView - this code is opening it in Normal view
    Very grateful for any assistance offered.

    [ This Message was edited by: haydnc on 2002-04-25 21:57 ]

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not use automation to run your slide show

    eg.

    Sub runPowerPointPresentation()
    Dim ppApp As PowerPoint.Presentation

    Set ppApp = GetObject("C:My DocumentspptPresentation.ppt")

    ppApp.SlideShowSettings.Run

    End Sub

    'Not tested !



    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Haydn Cooper
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ivan,
    Have tried this but this method creates an even larger problem for me as I have to resolve the issue of how to call the two Excel worksheets separately when one of them is already open - as per my original unanswered request for assistance. Having everything in the one Excel worksheet does at least overcome the issue!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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