Printing Excel VBA code

  VoG II 20:20 01 Jun 2004
Locked

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.

  Chris the Ancient 20:30 01 Jun 2004

Just checked some of my macros.

By 'eck lad, yer reet there!

I do get the indents - but not the colours.

I did a quick google on vba code printing and there's quite few utilities in there. But they want money!

Chris

  spikeychris 20:42 01 Jun 2004

THEY WANT WHAT!!

  Chris the Ancient 20:43 01 Jun 2004

Beer vouchers!

;o)

  VoG II 20:45 01 Jun 2004

Yeah, like click here *only* $59

What!?!

Gonna get my crayons and colour in the printout I think :o(

  Chris the Ancient 20:47 01 Jun 2004

Grasping at straws, I even checked whether my Code Librarian in Office Developer did it...



Nope!

  spikeychris 21:04 01 Jun 2004

I'd help you search but I don't have a clue what your talking about. Only thing I understood in this thread was beer vouchers.

  VoG II 21:09 01 Jun 2004

Not to worry ... thanks for the interest (in beer vouchers) anyway.

Thanks for your efforts also, Chris the Ancient.

I've posted the question in "the other place" - see what they come up with...

  Chris the Ancient 21:11 01 Jun 2004

Shame on you!

  Simsy 21:18 01 Jun 2004

but this seems to be what you want...

click here

Good luck,

Regards,

Simsy

  Chris the Ancient 21:22 01 Jun 2004

After 30 days, it's $89 !!

Get yer printing done quick!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?