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).

HotRod wrote:

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?

"Zigball" wrote in message
oups.com...
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.


HotRod wrote:
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?


--

Dave Peterson