Excel 2010 don't print my workbook

[bosstec]

Hi,

I have a big problem with my workbook.
After re-writing with more codes ect, I can not print it anymore.
Excel crashes and close when I try to print.

Here are a link to the workbook, if someone can have a look at it.
I have to admit, that this is first time i try to make some code in vba, and maybe the problem is located here.

Everything are in Danish...

http://dl.dropbox.com/u/14613820/Weekrepport rev1.xlsm

 

[Sektor]

Although your code is very messy and can be optimized considerably, I printed sheet successfully. Make sure you select correct printer and also try to reinstall drivers.

 

[bosstec]

Yes I can imagine, that the code are not perfect at all, but as I say, this is the first time for me.
However, it is strange for me, that you could print it. I tryed on other computers as well (Excel 2010) with the same problem.
Do you think the problem can be in the code?
I was trying to choose other printers as defaul, and even my PDF writer as default printer, but Excel crash anyway.
It even crash before i can choose printer.
It crash as soon as I hit the Print button under File, and this is not the case with other documents.

By the way. Any suggestion for optimzing my codes is more than welcome.

Thank
Frank

 

[Sektor]

Try this. Page Layout tab -> Page Setup dialog launcher (bottom-right corner). Make sure that you have correct paper size.

About optimizing. I don't think that it's easy to do fast 'cause it's required to know what this project does and what buttons and checkboxes shoould be enabled/disabled etc.

 

[bosstec]

Sorry, it's the same...
I even try to change papersize, margins, print area ect, but still the same problem.
BUT, I seems to work on Excel 2007.
This dosen't help me, because many of us in the company use Excel 2010.
What can be the problem here?