May 30, 2003 #1 zizis Programmer Joined May 30, 2003 Messages 3 Location GR How can i open a macro automatical when i open a workbook with Excel?
May 30, 2003 #2 KenWright Technical User Joined Mar 22, 2003 Messages 3,688 Location GB 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.............. Upvote 0 Downvote
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..............
May 30, 2003 #3 Edric Technical User Joined May 28, 2003 Messages 10 Location PH 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... Upvote 0 Downvote
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...