Auto macro

smund

Board Regular
Joined
Mar 15, 2005
Messages
52
I need to do a macro that begins automatic when I open teste.xls.
Please Help me.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

jimboy

Well-known Member
Joined
Apr 11, 2002
Messages
2,314
Hi - right mouse over the Excel icon to the right of File and select view code, then paste this in;

Code:
Private Sub Workbook_Open()
Call Macro1
End Sub

change the name of the macro from Macro1.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,407
Messages
5,547,771
Members
410,811
Latest member
adustin42
Top