Excel with macros printing blank sheet and corrupts display
Posted on 2002-07-01
This ones strange and we can only make this happen on one machine (unfortunately the machine is the MD's Dell Inspiron 8000)
We have a form we all fill in once a month which has 2 macros on it, 1 for printing (which seems a bit pointless) and 1 that clears the form.
We have used this form on Win95/98/ME & 2000
the laptop is running WinME
Office 97 is the package used and excel 97 is the ONLY application showing this problem.
Whether the form is blank or filled out, when you try and print it its prints a blank page, and recreates parts of the document in varying sizes all over the page, very strange corruption.
This happens even with the backup copy of the file that I keep remotely.
We have virus scanned and cant seem to find anything wrong.
Sometimes when the print request is run (especially from the print preview page) the spreadsheet crashes excel, but without any error code.
I hope this is something simple
We have re-installed office twice to try and fix the problem.
All that is left is a repair or reinstall of the o/s