Having "grown" a workbook over several years adding
little bits of code here and there I've made a mistake in
the code somewhere and excel closes as soon as I open the
workbook.

Is there a back door into the workbook just to look at
and alter the code?
There is no protection on the workbook or the code.