VBA Excel:A beginner questions

HI all,

Please, can someone let me know where should i put my syntax if i want it to preform whenever I execute the spreadsheet (Such as a MsgBox).

Is it a matter of syntax or the location of my code that make it to be authomatically opened

In addition, where should i save my macros in order to be opened in any given new spreadshhet?

Many Thanks,

Ben

Put your msgbox in the workbook open event in ThisWorkbook class.

VB Code:

Private Sub Workbook_Open()
    MsgBox "Opened"
End Sub

Thans for the help (-:

Oh, I missed the second part of your question. Save your macros and code to a personal macros sheet. When recording a
macro you will be prompted on the location of where to save to. :)

Cheers RobDog888 ;)