Is this possible? Help appreciated!

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

In a certain wookbook, I have a pre-set time entered in A1. (Let's sa
10:00 am next Monday morning)

When the pre-set time is reached...

If the workbook is closed, I want it to open automatically on Sheet1.

If the workbook is already open, I want it to change automatically t
Sheet1 (assuming that Sheet1 is not the sheet shown at the time).

This would be an -enormous- help. I already use a sticky note progra
that appears on top when the alarm goes off, but having the specifie
sheet of the workbook I want at the time popping up automatically woul
be even better.

Thanks in advance, Andre
 
I can help you with the first question. Use the 'Schedule
Task' in the Control Panel to schedule the workbook to
open at a perscribed time.

The second question would need some code and I'm not sure
how to write one that would jump automatically to a
certain sheet. Most code I know needs an even to trigger
it.

Maybe someone else will have an answer.
 
Hi Andrew,

If I wanted Sheet1 to be displayed when the workbook opened I would us
the "ThisWorkbook" Object (using the Workbook_Open() Event). My cod
would look like this:

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

I'm not sure how to get it to change sheets if it's already open.
suppose you could use a timer in your other sheets and set it to
second? Something like this:

Sub ChangeOnOneSecond()
Application.OnTime Now + TimeValue("00:00:01")
End Sub

Hope this help
 
Back
Top