excel add-in refresh
 

an excel add-in (which has a menu bar ) creates a spreadsheet. If a new
workbook is then opened, and then the someone goes back to the spreadsheet
created by the add-in, the add-in process which initially created the
spreadsheet attempts to create it a second time. Any idea what might be
causing the spreadsheet to re-run through processing when it is activated? It
only seems to happen the first time it is activated. After that the
recreation process does not happen.

tia
dk

excel add-in refresh
 

dk,

To have us figure that out, you would need to post all the code - macros, events, etc.

HTH,
Bernie
MS Excel MVP


"dk" wrote in message
...
an excel add-in (which has a menu bar ) creates a spreadsheet. If a new
workbook is then opened, and then the someone goes back to the spreadsheet
created by the add-in, the add-in process which initially created the
spreadsheet attempts to create it a second time. Any idea what might be
causing the spreadsheet to re-run through processing when it is activated? It
only seems to happen the first time it is activated. After that the
recreation process does not happen.

tia
dk

excel add-in refresh
 

Thanks for responding.

Not sure if all the code can be posted now. But breakpoints have been placed
in all the code, and when then add-in worksheet is activated, non of the
break points are hit - the code just begins reprocessing - reveal anything,
or heard of anything like this before?

thanks,
dk

"dk" wrote:

an excel add-in (which has a menu bar ) creates a spreadsheet. If a new
workbook is then opened, and then the someone goes back to the spreadsheet
created by the add-in, the add-in process which initially created the
spreadsheet attempts to create it a second time. Any idea what might be
causing the spreadsheet to re-run through processing when it is activated? It
only seems to happen the first time it is activated. After that the
recreation process does not happen.

tia
dk

excel add-in refresh
 

Most of the code is in a module and forms
The rest is in Workbook_AddinInstall()
and Workbook_AddinUninstall()

does the thread "Deactivate Events not Firing" seems to have a slightly
similar scenario when changing between workbooks - any thoughts?

"Bernie Deitrick" wrote:

dk,

To have us figure that out, you would need to post all the code - macros, events, etc.

HTH,
Bernie
MS Excel MVP


"dk" wrote in message
...
an excel add-in (which has a menu bar ) creates a spreadsheet. If a new
workbook is then opened, and then the someone goes back to the spreadsheet
created by the add-in, the add-in process which initially created the
spreadsheet attempts to create it a second time. Any idea what might be
causing the spreadsheet to re-run through processing when it is activated? It
only seems to happen the first time it is activated. After that the
recreation process does not happen.

tia
dk