Printing Excel VBA code

  VoG II 20:20 01 Jun 04
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 04

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 04

THEY WANT WHAT!!

  Chris the Ancient 20:43 01 Jun 04

Beer vouchers!

;o)

  VoG II 20:45 01 Jun 04

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 04

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



Nope!

  spikeychris 21:04 01 Jun 04

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 04

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 04

Shame on you!

  Simsy 21:18 01 Jun 04

but this seems to be what you want...

click here

Good luck,

Regards,

Simsy

  Chris the Ancient 21:22 01 Jun 04

After 30 days, it's $89 !!

Get yer printing done quick!

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…