Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scrollbar help [email protected] Excel Discussion (Misc queries) 1 January 19th 07 10:48 PM
scrollbar reslut makes another scrollbar to show Patrik Excel Discussion (Misc queries) 0 April 18th 05 03:11 PM
scrollbar on userform S.Hoitinga Excel Programming 7 April 5th 04 10:06 PM
Excel VBA - Userform Texbox/Scrollbar problem thesteelmaker[_5_] Excel Programming 2 March 6th 04 09:09 PM
Scrollbar settings in a UserForm mohsinb[_5_] Excel Programming 2 November 9th 03 06:04 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"