-
Solved: Auto Close WorkBook when Idle
Hi all,
I?m trying to get XLD's macro to work from http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER but have failed. It keeps coming up with an error with the below:
[vba]Application.OnTime Now + nElapsed, "Closedown", , False [/vba]
also tried, with no luck:
[vba]Application.OnTime Now + nElapsed, "Closedown", schedule:=False [/vba]
I come across this before and can?t figure out what I did to correct this and turn the timer off. Using Excel 2002
Could anyone please help !!
Thanks,
-
sorry guys, it working now. came back from lunch and hey presto !
not sure what went on but....
[vba]Application.OnTime Now + nElapsed, "Closedown", schedule:=False[/vba]
seems to be ok
thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules