Newbie needs help with "slideshow" macro

[xpatenaude]

This is my first post, as I am brand new today. I would like to ask for help creating a simple macro that displays some (not all) worksheets in a given workbook, for a predetermined (changeable) amount of time, (a slideshow). Thats it. I cant seem to figure it out. I tried creating many simple macros that simply select the workbooks, and then tried to use the CALL command combine with the OnTime code, but I had a lot of trouble looping it. I am runnung excel 2003. Please help

Thanks,

xpatenaude

[Bob Phillips]

Have a look at the Ontime method in VBA help, see where you get, and post back if it you need more help.

[xpatenaude]

I can get the OnTime method to function, but I cant get it to work continuously (loop). I have virtually no experience with loops. I pretty much want it to repeat over and over until I hit esc or ctrl break.

[Bob Phillips]

You get the procedure that Ontime fires to fire itself again in the required duration. All you would do in addition in that procedure is to increment the worksheet index, and reset when it overflows.

[xpatenaude]

Thanks. I'll give it a whirl!