I am getting this annoying error.

I will try to expain.

I have a form that opens on workbook open event.


User can't close form by clicking the x, but by hitting log off command button.

My problem is the sheet opens with the form, then when they click log off, it closes the workbook.

However,

The next time the sheet opens microsoft gives an error that says excel is shutting down and trying to recover documents.

Then I go back in under disable macros and do nothing but open the visual basic editor and close, then close the sheet.

Then I go back into the sheet and the form loads.

It seems to load once and then gives me an error the next time I open a workbook.



Could anybody help me with any ideas?


Thanks

Josh