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

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

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

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