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 Installing Addin Causes Serious Error in Excel 2002

Hi Red,

The problem appears to be uninstalling then reinstalling any
addin using the Workbook_Open() procedure.


WHat if you move the code out of workbook_open into a sub in a normal module
and call that sub from workbook_open.
If that doesn't help, try using the ontime method to call the sub

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com