View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_21_] Stuart[_21_] is offline
external usenet poster
 
Posts: 154
Default 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.