ontime method?
I created a macro that looks something like this:
Sub Macro7()
Application.OnTime TimeValue("07:00:00"), "Macro4"
End Sub
It works when I start it manually. Where would I insert the lines
relating to the Starttimer function so I can have the macro start
automatically each day? I looked at the related info on the Pearson
site but don't see how I would apply it to my situation. This is my
first experience with Excel macros and VBA.
|