I need help coming up with VBA that will put the Sheet's file name & a dash with the sheet name in cell M1 when the sheet's name is changed (right click sheeted tab & rename).

For example:

When changing tab named Sheet2 to 08-39 for the workbook TaxWorkSheets.xls,

put in cell M1:

TaxWorkSheets.xls-08-39

I really appreciate you help. mikeburg