Results 1 to 4 of 4
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Printing Modules (Excel XP)

    Short of dragging the text of my modules into a separate text file, is there a way to control the look of the printed module?the phone from a
    When I print, I basically have the choice between portrait & landscape. I want to also increase the size of the font (why else would I want to print).

    <font face="EraserDust">{Has anybody else seen annoying random words appearing in the input boxes on the Post form}from </font face=dust>
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing Modules (Excel XP)

    The print options of the VBA editor are very limited. I'm afraid you'll have to continue copying your code to a text editor or word processor to get more control.

    Do you have a cordless keyboard and/or speech recognition?

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Modules (Excel XP)

    There's a shareware tool here that appears to deliver fully formatted printed VBA (& other code). I don't know whether the price would seem sensible to you. I have never tried to use it.
    Gre

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing Modules (Excel XP)

    VBACodePrint, which is available at the site you posted, is an excellent tool. I use it often.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •