Userform Scrollbar

How can I prevent the vertical scrollbar on a form from being visible on the
printed copy, please?

Regards.

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" <[email protected]> wrote in message
news:uGTU%[email protected]...
> How can I prevent the vertical scrollbar on a form from being visible on
the
> printed copy, please?
>
> Regards.
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:uGTU%[email protected]...
>> How can I prevent the vertical scrollbar on a form from being visible on
> the
>> printed copy, please?
>>
>> Regards.
>>
>>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:uGTU%[email protected]...
> >> How can I prevent the vertical scrollbar on a form from being visible
on
> > the
> >> printed copy, please?
> >>
> >> Regards.
> >>
> >>
> >
> >
>
>

how about ..... is fine.
Again, ... many thanks for the instruction.

Regards.

"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> > news:uGTU%[email protected]...
>> >> How can I prevent the vertical scrollbar on a form from being visible
> on
>> > the
>> >> printed copy, please?
>> >>
>> >> Regards.
>> >>
>> >>
>> >
>> >
>>
>>
>
>