When you do this from the Visual Basic Editor it loses all formatting, i.e. colours, indentation and so on.
I'm sure that somewhere I've seen a utility to print VBA code in all its glory but I can't remember where or easily find it. This may be due to spending all day in front of a screen composing the code that I now want to print!
If anybody knows what I'm on about I'd appreciate a nudge in the right direction.