The code should go in the ThisWorkbook code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Brett" wrote in message
...
Thanks, but forgive my ignorance on this stuff....

Where do I put this code? In the same module as my other code?
For
arguement, lets call my macro I want to start "EZMAC". Should
the full code
look like this:

Open Event
Private Sub Workbook_Open()
EZMAC
End Sub

Is there a special place to put these modules?

Thanks again.


"Gary Keramidas" wrote:

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!