run macro on workbook open
 

Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?

In Excel, press <Alt<F11, type in Workbookopen and click on search

"kevin" wrote:

Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?

Sorry, once in VB, click on <F1, and then do the typing

"kevin" wrote:

Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?

Almost:

Private Sub Workbook_Open()
Call XYZ
End Sub

in the ThisWorkbook module

HTH. Best wishes Harald

"kevin" skrev i melding
...
Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?