Rudi,
That does not work with a UserForm though.
Somehow the default printing out format of a userform is 'portrait'. I
cannot change it to 'landscape,
Maybe there is an option with newer version than mine (Excel'97).
Gabor
"Rudolf Sommer" schrieb im Newsbeitrag
...
I think you have to choose the orientation in the printer dialog, using
the
printer's properties.
HTH
Ruedi
"Gabor" schrieb im Newsbeitrag
...
Hi,
If I print the userform out, it comes as 'portrait'
Can anyone tell me how to print 'landscape' and centralised on the page?
Thanks folks
Gabor