Thread: MultiPage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cliff Myers Cliff Myers is offline
external usenet poster
 
Posts: 48
Default MultiPage

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.