Thursday, March 25, 2010

Run A Macro By Opening A File

Eric,

Referring to your question on how to run a macro when you open a file with the condition if current time is between 9 am and 10 am, otherwise, don't run this macro.

I had create a Open event at the ThisWorkbook objects. You can use the If statement below, and change Msgbox below to Run to run your macro.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.