Userform Scrollbar
how about ..... is fine.
Again, ... many thanks for the instruction.
Regards.
"Tom Ogilvy" wrote in message
...
how about
Me.Scrollbars = fmScrollBarsNone
-----------------------------
Other choices:
fmScrollBarsNone 0 Displays no scroll bars (default).
fmScrollBarsHorizontal 1 Displays a horizontal scroll bar.
fmScrollBarsVertical 2 Displays a vertical scroll bar.
fmScrollBarsBoth 3 Displays both a horizontal and a vertical
scroll
bar.
--
Regards,
Tom Ogilvy
"Stuart" wrote in message
...
Yes, a Userform.
In the Sub: CbPrint_Click( ) I've been looking to do that.
If I add the line: Me. then Intellisense throws me these options ....
KeepScrollBarsVisible, Scrollbars and
VerticalScrollBarSide.
I cannot make any of these work.
Regards
"Tom Ogilvy" wrote in message
...
If you mean on a userform, you would have to make it visible = False
before
you did printform and then turn it back on .
--
Regards,
Tom Ogilvy
"Stuart" wrote in message
...
How can I prevent the vertical scrollbar on a form from being visible
on
the
printed copy, please?
Regards.
|