I have set up a lovely looking Dashboard in excel, to be used by a number of people around the office, the problem is that it doesn't print properly.
I've discovered that there is an issue (and always has been) with excel, as it doesn't print shapes or pictures very well. They are distorted / not on the page - and through a lot of googling, it doesn't appear that there is a solution to the problem.
Trying to think my way around this issue, I contemplated adding my own print button that would:
1) Save the file as .html
2) Print the .html file
I tried using the code from the link below to print the resultant html file, it does print, but the page layout isn't set to landscape and so it doesn't fit on one page ...
http://www.jpsoftwaretech.com/open-or-print-files-in-vba/
Does anyone have any thoughts as to how I can have excel create the html file and print it - while being able to specify that it prints on one page, landscape?
I've discovered that there is an issue (and always has been) with excel, as it doesn't print shapes or pictures very well. They are distorted / not on the page - and through a lot of googling, it doesn't appear that there is a solution to the problem.
Trying to think my way around this issue, I contemplated adding my own print button that would:
1) Save the file as .html
2) Print the .html file
I tried using the code from the link below to print the resultant html file, it does print, but the page layout isn't set to landscape and so it doesn't fit on one page ...
http://www.jpsoftwaretech.com/open-or-print-files-in-vba/
Does anyone have any thoughts as to how I can have excel create the html file and print it - while being able to specify that it prints on one page, landscape?