Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Go To A Slide

  1. #1
    Join Date
    16th April 2007
    Posts
    67

    Go To A Slide

    Greetings,
    I want a macro to go to slide 4 after it has done some other business. I used the code below;

    VB:
    With SlideShowWindows(1) 
        .View.GotoSlide (.Presentation.Slides(4).SlideIndex) 
    End With 
    
    
    It comes up with the error, “SlideShowWindows (unknown member): Integer out of range. 1 is not in the valid range of 1 to 0.”

    I would swear 1 is in the range 1 to 0...

    Help please,
    Benny

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Go To A Slide

    I get that error when running the macro in design mode. If the slide show is running it works.
    Try this variation for going to the slide in either mode.

    VB:
    If Application.SlideShowWindows.Count = 0 Then 
         ' make slide 4 active in design mode
        ActivePresentation.Slides(4).Select 
    Else 
         
         ' this will work in slide show mode.
        With SlideShowWindows(1) 
            .View.GotoSlide (.Presentation.Slides(4).SlideIndex) 
        End With 
    End If 
    
    

    Cheers
    Andy


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Customize The Slide
    By david_reinjal in forum Excel and/or Powerpoint Help
    Replies: 1
    Last Post: April 3rd, 2007, 16:22
  2. Selecting a slide or putting a slide in view
    By bwells in forum Excel and/or Powerpoint Help
    Replies: 11
    Last Post: August 12th, 2006, 01:30
  3. PPT next slide
    By ljoseph in forum Excel and/or Powerpoint Help
    Replies: 1
    Last Post: October 27th, 2004, 03:26

Bookmarks

Posting Permissions

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