VBA Excel:A beginner questions

[offir1]

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

[RobDog888]

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

Private Sub Workbook_Open()
    MsgBox "Opened"
End Sub

[offir1]

Thans for the help (-:

[RobDog888]

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.

[offir1]

Cheers RobDog888