How can make a macro to run evey one hour-automatically
 

Is there a way that I can run a macro in a spreadsheet on every one hour or
so (automatically and while Excel is opened) but without making Excel to be
tied-up with a FOR NEXT Loop and I think this would be a bad practice... is
there a way??

Thank you in advance

How can make a macro to run evey one hour-automatically
 

Chip Pearson explains how to use application.ontime:
http://www.cpearson.com/excel/ontime.htm

SAM SEBAIHI wrote:

Is there a way that I can run a macro in a spreadsheet on every one hour or
so (automatically and while Excel is opened) but without making Excel to be
tied-up with a FOR NEXT Loop and I think this would be a bad practice... is
there a way??

Thank you in advance

--

Dave Peterson

How can make a macro to run evey one hour-automatically
 

Thank you Dave, I will try that.
--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western International University Associate Programs
(alternate email) Phone #:
(405)315-8223 Time zone: Pacific Time
"Dave Peterson" wrote in message
...
Chip Pearson explains how to use application.ontime:
http://www.cpearson.com/excel/ontime.htm

SAM SEBAIHI wrote:

Is there a way that I can run a macro in a spreadsheet on every one hour
or
so (automatically and while Excel is opened) but without making Excel to
be
tied-up with a FOR NEXT Loop and I think this would be a bad practice...
is
there a way??

Thank you in advance

--

Dave Peterson