I would be grateful for any advice on how to set margins and cell
widths in Excel so that when the document is printed the printed
document reflects, accurately, the settings made.
I have tried using VBA and also the ribbon facilities, but in both
cases my settings do not accord with a subsequent print except to the
extent that the larger the setting the larger the width.
Kind regards
Brian
Some suggestions...
Setting a zero margin will always result a default 0.25 margin;
This is built into your printer so not much you can do about this
unless you can send commands to it to do otherwise.
Set header/footer margins to ALWAYS be less than top/bottom margins;
Do all settings in PrintPreview so Excel displays page boundaries after
closing that window. Now you can...
Adjust column widths to suit your desired layout for the displayed page
boundaries.
Note that setting Print_Area will affect page boundaries, so you need
to establish what range of columns you want to fit on a printed page. I
always set width of the 1st col to the right to 1 or 2 so I know where
the right limit is if the page boundaries from PrintPreview haven't
been set yet; -usually after opening the file, and before previewing
the 1st time during a session.
When designing forms, note that FontSize affects RowHeight unless you
manually specify row height for specific rows. My default font is Arial
8pt just because I like that font, and that size gives me 30 columns of
screen real estate at the default col width. This, of course, varies
with display size; the above is for my 17" laptop w/1920x1200
resolution. This 13" laptop only gives me 24 cols at 1366x768
resolution. (Zoom=100%)
I do a lot of authoring in Excel and following these guidelines has
always given me predictable, reliable printing results.
HTH
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion