printing out vba code

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing out VBA code in colour

Printing out VBA code in colour

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.