Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
timer Macro
Looking for help in making a stop macro the below timer macro
Timer works but seems to continue running Public Sub timer1() Application.OnTime Now + TimeValue("00:00:5"), "stop1" End Sub Thanks Leon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
timer Macro
I've not done much with OnTime, but with the help of this group I got the
following line working. Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3), procedu="UnhideColumns" -- Ian -- "Puzzled" wrote in message ... Looking for help in making a stop macro the below timer macro Timer works but seems to continue running Public Sub timer1() Application.OnTime Now + TimeValue("00:00:5"), "stop1" End Sub Thanks Leon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
timer Macro
Thank you
"Ian" wrote: I've not done much with OnTime, but with the help of this group I got the following line working. Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3), procedu="UnhideColumns" -- Ian -- "Puzzled" wrote in message ... Looking for help in making a stop macro the below timer macro Timer works but seems to continue running Public Sub timer1() Application.OnTime Now + TimeValue("00:00:5"), "stop1" End Sub Thanks Leon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
timer Macro
You're welcome. Nice to get the feedback.
-- Ian -- "Puzzled" wrote in message ... Thank you "Ian" wrote: I've not done much with OnTime, but with the help of this group I got the following line working. Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3), procedu="UnhideColumns" -- Ian -- "Puzzled" wrote in message ... Looking for help in making a stop macro the below timer macro Timer works but seems to continue running Public Sub timer1() Application.OnTime Now + TimeValue("00:00:5"), "stop1" End Sub Thanks Leon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timer macro | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Macro With Timer Event | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |