Run a macro when opening spreadsheet

Afternoon All,

i need to know how to activate a macro when opening a workbook. Each day the workbook has the same beginning of the name for example cash, but the last part is a number which changes daily. All i want to do is run the macro when opening any workbook that begins with the word cash...

Thanks for any help.

Craig.

The easiest way to run a macro when a workbook opens is to place your code in the ThisWorkbook module in the Workbook_Open subroutine.