Hi

I have an excel workbook which i have written some VBA and Macros in.

If the programme is left open running in the background when i come to use one of the userforms it lefts me open it and fill out all the pages but when i submit it i get a debug at the save part of the code.

This only happens if it has been left open and idol. When it is first opened it works well.

Does anyone know why this might be happening, and is there anything i can do to correct it.

Thanks