A spreadsheet I'm working on is calculating days since an injury has occurred. I have a macro set up in my VBA editor that recalculates it every (x) minutes/hours/whatever I set it up as. When I paste the object into powerpoint to run on our warehouse displays it will refresh a few times, but then cease. I'm thinking that it's an issue with excel not continuing the macro when it's not the active window. Is there a way to tell my PC that excel is still active even when another application is being worked in? Here's my simple code:
If I'm incorrect in my assumption that excel is the issue, I'll gladly take that advice too! Thanks all!
Code:
Private Sub Workbook_Open()
mycalc
End Sub
Sub mycalc()
Application.OnTime Now + TimeValue("00:01:00"), "mycalc"
Sheets("InjuryClock").Calculate
End Sub
If I'm incorrect in my assumption that excel is the issue, I'll gladly take that advice too! Thanks all!