auto run macro

[Guest]

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

 

[Guest]

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_x]

For example : change the color to yellow

<pre>
Private Sub Workbook_Open()
Cells.Select
With Selection.Interior
.ColorIndex = 6 '(colorindex 6 = yellow)
.Pattern = xlSolid
End With
Range("A1").Select
End Sub

</pre>