+ Reply to Thread
Results 1 to 6 of 6

Worksheet Slideshow in Excel 2010

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    9

    Worksheet Slideshow in Excel 2010

    Hello,

    I have 2 tabs in my excel workbook and I would like to use 20 second increments to transition between the 2 worksheets. Ideally, the slideshow would be controlled by a start/stop button but that isnt a big issue. The more important thing is to transition between the worksheets. Appreciate your help in this matter.

    Thanks.

    HQ

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Worksheet Slideshow in Excel 2010

    Please Login or Register  to view this content.
    Put the above in a code module
    assign a command button to startTimer
    assign another command button to stop timer
    adjust worksheet names to suit
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Worksheet Slideshow in Excel 2010

    excelforum.png

    Thanks for the help. I ran the code as you have written and changed the "sheet1" name to match my sheet. However, I encountered the following error message when running. I have attached the image of the module and error message I recieved. Appreciate your help.

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Worksheet Slideshow in Excel 2010

    Sorry, you have to put the code into a code module not a sheet module..

    1. Open your workbook.
    2. Right click on a worksheet tab and select "View Code"
    ......... The window will now switch to the VB editor.
    3. Find your Vb project in the project explorer window (which should be to the left) and will have the same name as your workbook.
    4. Right click on the project and select "Insert Module"
    5. Double click on module 1
    6. Paste the code for the sub savebook into the module
    7. Insert a shape onto your worksheet
    8. Right click on the shape and select "Assign macro"
    9. Select the macro from the displayed list
    10. Edit the code above to suit.

  5. #5
    Registered User
    Join Date
    04-09-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Worksheet Slideshow in Excel 2010

    Thanks for that. Just to clarify, the only place in the code where I am making an edit is the line:
    If ActiveSheet.Name = "Sheet1" Then

    or should I also be changing sheet4.activate and sheet2.activate to the names I have given the respective worksheets ?

  6. #6
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Worksheet Slideshow in Excel 2010

    You need to change all the sheet names in my code to whatever suits you.. The program toggles between the two sheets at the set time interval.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1