Stupid question:

How do you run the timer?


Ideally I would like this to run automatically. That is
I would use Scheduled Tasks to bring the worksheet up
then later in the day have the copy macro run so I don't
want to have to run the timer unless this can be done
automatically when the spreadsheet comes up.


thanks



-----Original Message-----
Did you run Timer?

In article ,
"Mike" wrote:

hi,

I created a copy macro within Excel that I need done
at a
certain time each day. The copy macro (called copy3)
is
under the Modules portion in Visual basic.

I put the following in the Sheet2 page in Visual basic:

Private Sub Timer()

Application.OnTime TimeValue("13:00:00"), "copy3"

End Sub


And it does not run the macro at 13:00.

What have I done wrong?
.