Running a VBA app when a workbook is opened

I have a workbook application that just deletes a sheet from another workbook, copies a new sheet in its place, then closes both workbooks. (It's to be distributed as an update to the other workbook)

Is there a way to get it to run as soon as the user opens it in Excel - the user never actually needs to see it at all.

richard

Yes, investigate the Workbook_Open event in the ThisWorkbook module.