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.

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" wrote in message
...
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
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

-----Original Message-----
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" wrote
in message
...
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.


.

See Chip Pearson's site

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

--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
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

-----Original Message-----
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" wrote
in message
...
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.


.