Discussion Locked

Scrollbars in UserForm Word 2000

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All:
My question is this:
I have created a template with an attached userform. This form works great, but I just found out one individual who is using this is sight impaired and her screen is set to 640X480 resolution. The entire userform cannot be screen at this resolution and while the scrollbar properites are visiable on the form, they are not active. The button in the scrollbar which scrolls the form does not show, and she cannot see the scroll bar anyway with this resolution. So I need to make them visible at that resolution as well as activate them. Any help? I have looked extensivly for info and cannot find any....

4 replies

by dklippert

Here are some suggestions from various forums.

Put a zoom button on the form with code like:

ActiveWindow.View.Zoom.PageFit = wdPageFitBestFit

Or you could use something like:

Dim Res As String
Res = System.HorizontalResolution
If Val(Res) < 800 Then
ActiveWindow.View.Zoom.PageFit = wdPageFitBestFit
Else
ActiveWindow.View.Zoom.Percentage = 100
End If

"To activate the scroll bars set the ScrollHeight and ScrollWidth properties to something greater than the Height and Width properties respectively. If you think of
the Height and Width properties as setting the "visible" area of the userform, then the ScrollHeight and ScrollWidth properties set the "total" area of the userform that can be accessed with the scrollbars."

by creed

Thank you, this answer helped me ascertain the way to figure this out, and it finally worked out on the User Form. Thanmk you so much for all your help!

by creed

Hi dklippert,
I have tried your suggestions, and it doesn't open up the userform attached to the template in any other mode other than that horribly large screen.
Would you know of any other suggestions to try?
Thanks, Connie

This discussion is closed to new replies.