Open Event
See AlsoApplies ToExampleSpecifics
Occurs when the workbook is opened.
Private Sub Workbook_Open()
Example
This example maximizes Microsoft Excel whenever the workbook is opened.
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub


--


Gary


"Brett" wrote in message
...
This is likely quite a simple question, but I have not been able to find
this
in the online help of Excel or on the boards.

I have built a nice little Excel app to display some real time data. The
macro works wonderfully and I am very statisfied with it.

What I need to do is lauch that particular macro whenever this document is
opened. I am trying to make this as easy as possible for my end user, and
this would surely do it.

TIA!