98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing out VBA code in colour
Printing out VBA code in colour
Resolved · High Priority · Version 2007
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
Wed 30 Sep 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting only Text cellsTo select onlt text value cells in a spreadsheet, click on Edit-Go to(F5) |