Open Macro

[zizis]

How can i open a macro automatical when i open a workbook
with Excel?

 

[KenWright]

Either use the Workbook open event in the ThisWorkbook module
Private Sub Workbook_Open()
myMacro
End Sub

or use a macro called Autpen in a normal code module
Private Sub Autpen()
myMacro
End Sub

Regards
Ken..............

 

[Edric]

While in Excel click Visual Basic Editor, then Click Visual Basic help. You can read the basic of VBA. It is where I started.

Good luck...