How to run a presentation of Excel ?

[johnie123]

Hi,

I am a total newbie at excel programming.
I have no knowledge in VBA programming, and macros.

I have a simple excel document with 4 sheets.

My boss asked me if there's a way of doing the following thing :

When pressing a button, or starting a macro - every 15 seconds,
a different spread-sheet will be shown.

Meaning :

Spread-Sheet 1 is shown.
.... 15 seconds ...
Spread-Sheet 2 is shown.
.... 15 seconds ...
Spread-Sheet 3 is shown.
.... 15 seconds ...
Spread-Sheet 4 is shown.
.... 15 seconds ...
Spread-Sheet 1 is shown.
.... 15 seconds ...
Spread-Sheet 2 is shown.
.... 15 seconds ...

etc ...

It's cause we have it shown on a large screen for all the workers,
and we wish to cycle the sheets, so everyone sees all the information.

Is there a way of doing so in a piece of code or macro or button ?

And if so - how do I stop it if I want to edit the information in one of the sheets ?

Thank you very much in advance,
Johnie

[JONvdHeyden]

Hello Johnie

Do you mean you want to show different workbooks or different sheets in the same workbook?

Using macro's may involve using OnTime, see here for introduction: http://www.cpearson.com/excel/OnTime.aspx

But why not rather just create a menu of hyperlinks and use that to dart between reports? Maybe have a next button on each sheet, where the button is hyperlinked to the next report that you want to show...

[johnie123]

Hello Johnie

Do you mean you want to show different workbooks or different sheets in the same workbook?

Using macro's may involve using OnTime, see here for introduction: http://www.cpearson.com/excel/OnTime.aspx

But why not rather just create a menu of hyperlinks and use that to dart between reports? Maybe have a next button on each sheet, where the button is hyperlinked to the next report that you want to show...

Hi,

Thanks for the quick reply.

The sheets (not workbooks) of this one workbook must be cycled AUTOMATICALLY, because it's shown on a big screen TV in the office.

We want to show 1 specific workbook, and cycle periodically (every x seconds) through it's sheets. Each sheet shows information relevant to a different team here.

So it sounds like the OnTime is the right direction, but how do I start it ?
Using a button ?
How do I stop it ?
And how do I tell it the duration to wait between cycling the sheets ?
Can I save a global variable that says which sheet is shown now from 0-3 ?
(I've read about the function : sheets(i).Activate which is what I need, I think)

[JONvdHeyden]

Hello again

Copy this code to a module in your workbook. It will activate the next sheet each 15 seconds. The first sheet will remain visible for 15 seconds before toggling to the next.

Please Login or Register  to view this content.

To run this hit ALT+F8 and run NextSheet from the list.

To stop it hit ALT+F8 and run StopTimer from the list.

[Dave69rock]

Hi

maybe this will get you started but knowledge of this is limited.

Create a button from the forms menu: View>Toolbars>Forms create a button.

record a macro and add this
I'm not sure how to pause it though.

Please Login or Register  to view this content.

[Phil_V]

From Jons code, I believe the final function needs altering as follows:

Please Login or Register  to view this content.

Then to start it run 'StartTimer', not 'NextSheet'

[JONvdHeyden]

From Jons code, I believe the final function needs altering as follows:

Please Login or Register  to view this content.

Then to start it run 'StartTimer', not 'NextSheet'

Yup, that also works, thanks Phil...