Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
scrollbar on userform | Excel Programming | |||
Excel VBA - Userform Texbox/Scrollbar problem | Excel Programming | |||
Scrollbar settings in a UserForm | Excel Programming |