Hi.

I have converted an old Excel 2003 spreadsheet with VBA in it to an Excel 2010 macro enabled workbook.

The spreadsheet has some code to create a custom menu when the workbook is activated (or remove it when deactivated) but the code is not firing when I first open the workbook. I can create a new one and then switch back which then runs the code. I have even added a Workbook Open event to run the code but this doesnt work either.

Can anyone help me with why the code isn't running?