Open your VBA editor with Alt + f11 and double click "This Workbook". Use:

Private Sub Workbook_Open()
MyMacro 'The name of your macro
End Sub

The open event will initiate your macro.



"violet" wrote:

i need the workbook to auto run the macro from personal.xls once i open the
workbok?how can i do that?