I've got a setup with 2 excel spreadsheets: a Parent and a Child. The
child contains a number of Listboxes that when changed run different
macros to update the data.

The Parent has a VBA macro that opens the Child, ammends some data and
then Saves the child as a different filename using the Save As
function. The SaveAs function then runs the Listbox macros in the
Child, but these can't complete properly for some unknown reason.
Accordingly I get VBA crashing out.

I've spent the majority of the afternoon searching through various
groups on the web to try and find a way of disabling the Listbox
macros (or forcing them to run before the Save As) or any other
workaround i can find. And I think i've tried every possible version
of Enabling/Disabling events to no avail.

Can anyone help me. Thanks.