View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Resetting Excel commandbars on close event

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