Launch Macro at startup

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

This goes with my question below but. I want to launch a "loop" macro when
the excel sheet is opened to monitor the time and then run another macro
when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
Also is there a better way to monitor the time than in a WHILE <> Loop?
 
Not sure if this is what you are looking for:

Public Sub LoopMacro()

LoopMacro.Show vbModal

End Sub
 
Disregard the first message you want to put this in the workbook

Private Sub Workbook_Open()

LoopMacro.Show vbModal

End Sub

Create a module for the Loopmacro.
 
Private Sub Workbook_Open()

Doesn't seem to work. Even after closing and opening the workbook the cde is
not executed. Am I missing something?
 
Make sure you put that procedure under ThisWorkbook--not behind a worksheet, not
in a General module.

And make sure you allow macros to run when you open that file (check your
security settings).
 
Im usually on the question end of this forum so I would probably re
submit my question if i were you. If I am not mistaken you are trying
to get a macro to start at start up if this is correct please disregard
all my solutions because those are simply for starting up user forms at
start up. Good luck and I am sure you will get the correct answer
because this is probably one of the best places to get a right answer
for any questions or problems one might have, sorry!
 
I managed to get it working once I moved the code into the Workbook into the
sheet. Stupid rookie mistake..
 
Back
Top