gs99
Programmer
- Oct 7, 2001
- 40
When you print VBA code, can you change the formatting to get a wider margin on the left side?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBA code printing - formatting left margin
- Thread starter gs99
- Start date
- Status
origapizni
Programmer
Not really an answer to your question, but I often use a very good freeware package called PrettyCode.Print located at
No nag screens, no expiration, very stable, and totally free.
It prints in color (a major irritation with the VB Editor) and works very well. It also brackets block If, With, Case structures to make them easily identifiable.
No nag screens, no expiration, very stable, and totally free.
It prints in color (a major irritation with the VB Editor) and works very well. It also brackets block If, With, Case structures to make them easily identifiable.
- Thread starter
- #3
gs99
Programmer
- Oct 7, 2001
- 40
Pretty Code Print seems to be a nice product for VB.
But it seems to have some drawbacks for VBA, from what I've seen:
It's not native to VBA yet; you need to copy each module from VBA into PCP's clipboard. The module name is lost. The left side margin is more than Microsoft's VBA but could not find a means to adjust.
It seems odd that VBA gives more power to the spreadsheet, but the programmer has no power to adjust the printed page of VBA code.
What I'm looking for is Page Setup for VBA code print.
But it seems to have some drawbacks for VBA, from what I've seen:
It's not native to VBA yet; you need to copy each module from VBA into PCP's clipboard. The module name is lost. The left side margin is more than Microsoft's VBA but could not find a means to adjust.
It seems odd that VBA gives more power to the spreadsheet, but the programmer has no power to adjust the printed page of VBA code.
What I'm looking for is Page Setup for VBA code print.
- Status
Similar threads
- Locked
- Helpful tip
