EXCEL macro : running event when starting workbook

We can actually automatically run a macro, trigger event when we open a workbook.
The code is as below
=================================================
Private Sub Workbook_Open()

MsgBox ("Welcome to script aku")

End Sub
=================================================

However, in order to do this do not write the code inside module.
Write the code in Workbook as below picture.





No comments:

Post a Comment