auto run macro

Is there a way to automatically run a macro any time a workbook is opened?
Thanks,

[Paul B]

sure put the code in thisworkbook code replace msgbox with your code

Sub auto_open()
MsgBox "your text here"
'put in module will display a msg box with your text
'when workbook is opened
End Sub

[gplhl]

Enter into ThisWorkbook in the VB Editor for the workbook you want the code to run.

Private Sub Workbook_Open()

' your code here or reference to your macro.
End Sub

On 2002-03-03 21:42, gplhl wrote:
Enter into ThisWorkbook in the VB Editor for the workbook you want the code to run.

Private Sub Workbook_Open()

' your code here or reference to your macro.
End Sub

a little sub-question about this problem.
Is it possible that when the workbook is open the screen will automatic change in a specific color?
Thanks.

[Bruno]

For example : change the color to yellow

Private Sub Workbook_Open() 

    Cells.Select

    With Selection.Interior

        .ColorIndex = 6       '(colorindex 6 = yellow)

        .Pattern = xlSolid

    End With

    Range("A1").Select

End Sub