Startup Macro

[aparna]

How do I make a macro run automatically when a excel file is opened. What do I name this macro.
Aparna

 

[Oaktree]

In the ThisWorkbook module, put:

Private Sub Workbook_Open()
'rest of code in here
End Sub

 

[al_b_cnu]

Hi,

Right-click any worksheet tab, select 'View Code', then select 'ThisWorkbook' from the list on the left and insert the following:

Private Sub Workbook_Open()
MsgBox "Hello"
End Sub

 

[aparna]

I tried using this code the way you indicated...but it didn't work.

Private Sub Workbook_Open()
Range("A1").Select
End Sub

Excel does't run this code during startup. Is there anything else that i need to do

Aparna

 

[Oaktree]

Did you put it in the ThisWorkbook module and enable macros?