MultiPage

[Michael]

Hi All
I am currently using a 7 Tab MultiPage to show different
products on an Excel Worksheet. I have to manually open
and change tabs to see each product.
Is it possible to, when the MultiPage opens, to randomize
and show each tab for 10secs and then either interrupt or
let it close itself. Basically a slide show, I guess.

Regards
Michael.

 

[Cliff Myers]

I'm not sure about the random opening worksheets but in the workbook open
event you could use the OnTime method to show whichever sheet you wanted
then duplicate it to show the next sheet and so on, when you reached the
last sheet just enter Close Workbook.

HTH

 

[Michael]

Cliff
Thanks for your response. I am probably expecting too much
from Excel but this seems a logical way to do what I want.
I have 2 Walkenbach books but neither of them seem to shed
much light on the OnTime method.

Can you enlighten me any further on this method.

Regards
Michael

 

[Tom Ogilvy]

See Chip Pearson's site

http://www.cpearson.com/excel/ontime.htm