Excel - Using VBA to create menus

At what point can I run a peice of VBA to create a temporary menu for my Excel Spread sheet.

In workbook_open _activate etc the comandbars variable hasn't been initialised.

Regards,

James.