Hi All

I have two workbooks with various stuff in the
workbook.activate procedures, now the problem is that if
I have both workbooks open and get the macro to close the
initial workbook the next workbook that is defaulted to
does not run any code in the workbook.activate procedure
or in the (windowactivate in sheetactivate).

Does anyone know how to force these to run. It seems to
work if I just click to close tab on the window but
something different must happen when I run macros as it
doesn't perform in exactly the same way.

Thanks heaps
Jase