Ta Spicy
Yes it is a spreadsheet with some macros (VBA), and it is on the server to be used from many locations. I'm not at work at the moment to give you the exact error code but 1004 also seems to appear at times all when the user tries to close the application.