I have a workbbook which runs code in the 'ThisWorkbook'. At the present
time the programme is opening and closing without being able to do any
editing. I need to be to edit the code in the 'ThisWorkbook' routine to
prevent this.

Is there a way to prevent this code being run when opening. I have tried
the CRTL key and the Shift key but this doesn't work.

Any solutions would be greatly appreciated!

Mark