Hi Alanperu,
I am using the workbook_close event to execute some code already, but I
find that when I try to reset the command bars directly from this event
handler Excel just freezes.
Try moving the code that handles the commandbars to a sub in a normal
module. Call that sub from the Workbook_BeforeClose event.
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com