any way to call a marco every 10mins?

[yellowpower]

any way to call a marco every 10mins?

[royUK]

Look for the Ontime method

[st0kvis]

i wanna know about ontime in EXCEL 2010. i got this code online and it does not work as it shows the form then does not unload it after the alloted time. In other words the useform does not go away after 5 seconds


This is the code:

Sub Workbook_Open()
MyStartupForm.Show
End Sub

Private Sub MyStartupForm_Activate()
Application.OnTime Now + TimeValue("00:00:05"), "Kill_The_Form"
Unload MyStartupForm

End Sub

Private Sub Kill_The_Form()
Unload MyStartupForm
End Sub

[Domski]

any way to call a marco every 10mins?

Pay someone to lean out of the window and shout his name

I'll get my coat...

[Domski]

st0kvis

Please start a new thread rather than asking a question in someone else's per the forum rules:

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom

[watersev]

example:

Please Login or Register  to view this content.

It runs every 5 seconds. Do not forget to think of the way you will stop it