Printing out VBA code in colour

Resolved · High Priority · Version 2007

Mon 21 Sep 2009, 16:27 Delegate Howard said...

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 ?

Thu 24 Sep 2009, 11:01 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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