Automatically switching between worksheets.
You can do this using VBA and the OnTime method.
Chip Pearson has code at his site.
Use the OnTime code to run this Sub after Sheet1 has been active for a period of
time that is appropriate for your needs.
Sub switch()
Sheets("Sheet2").Activate
End Sub
Gord Dibben MS Excel MVP
On Wed, 6 Dec 2006 07:35:01 -0800, dinouk
wrote:
Hi hope someone can help me...
we display a worksheet on a screen via a projector, the workbook at the
moment only has one work sheet, we now wish to add a further worksheet to
this workbook and have the display automatically switch from one sheet to the
other after a predetermined time delay.
Is this possible?
|