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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?