Howard has attended:
Excel VBA Intro Intermediate course
Printing out VBA code in colour
Following up on delegate Katya's questions on Printing (15/09/09 & 18/09/09), I have easily managed to print the contents of the current Code Window by simply selecting 'Print' from the 'File' drop-down menu. However, the resulting prinout is not very user friendly as it defaults to all black text, even when I select Colour printing via the 'Setup' and 'Properties' buttons. I want to be able to quickly differentiate between the code and the (green) comments without having to spot the leading 's (apostrophes).
The only way I have managed to print out my VBA code just as it appears on screen is to do an individual page-by-page 'Print Screen' which I then paste into Word. This method is a real pain, as some of the macros I have inherited go to dozens of pages.
Is there a simpler way of printing out VBA code in colour ?
RE: Printing out VBA code in colour
Hi Howard
Thanks for your question
I have looked into this and it seems that the text is saved as unformatted text. This means that when you paste the code into another application, or print it all formats are lost.
I can find no better way to do this than the method you describe. I will however continue to look into this and if a find a solution I will post a follow up
Regards
Stephen
