How can I get a user form to maximize on user screens during show process? I have played with Zoom but need more. Thanks for your help
--
George G

Hi Sgwapt

Private Sub UserForm_Initialize()
With Me
..Height = Application.Height
..Width = Application.Width
End With
End Sub

Note that objects on the UserForm will not adjust in size proportionately to
the UserForm's size

--
XL2002
Regards

William



"Sgwapt" wrote in message
...
| How can I get a user form to maximize on user screens during show process?
I have played with Zoom but need more. Thanks for your help
| --
| George G

You shouldn't use the entire screen for trivial information like this. The
user should be allowed to browse the web or watch a movie in the meantime.
Use no more than this info needs, probably something like 300*50 pixels.

HTH. Best wishes Harald

"Sgwapt" skrev i melding
...
How can I get a user form to maximize on user screens during show process?
I have played with Zoom but need more. Thanks for your help
--
George G

Thanks William, this helps very much. Al I have to do now is adjust the objects.

Thanks again
--
George G


"William" wrote:

Hi Sgwapt

Private Sub UserForm_Initialize()
With Me
..Height = Application.Height
..Width = Application.Width
End With
End Sub

Note that objects on the UserForm will not adjust in size proportionately to
the UserForm's size

--
XL2002
Regards

William



"Sgwapt" wrote in message
...
| How can I get a user form to maximize on user screens during show process?
I have played with Zoom but need more. Thanks for your help
| --
| George G

Yes, I understand your message Harald. My only Intention is for database systems at work. I have been having problems with "button happy", "not authorized", "changing values", etc personnel that I have to prevent the data from being changed by them as these systems get bigger. I am trying to change to XLA format that will take care of this but boss man is in the way.

Thanks for the feedback. I will keep plugging and enjoy.

--
George G


"Sgwapt" wrote:

Thanks William, this helps very much. Al I have to do now is adjust the objects.

Thanks again
--
George G


"William" wrote:

Hi Sgwapt

Private Sub UserForm_Initialize()
With Me
..Height = Application.Height
..Width = Application.Width
End With
End Sub

Note that objects on the UserForm will not adjust in size proportionately to
the UserForm's size

--
XL2002
Regards

William



"Sgwapt" wrote in message
...
| How can I get a user form to maximize on user screens during show process?
I have played with Zoom but need more. Thanks for your help
| --
| George G

"Sgwapt" skrev i melding
...
Yes, I understand your message Harald. My only Intention is for database
systems at work. I have been having problems with "button happy", "not
authorized", "changing values", etc personnel that I have to prevent the
data from being changed by them as these systems get bigger. I am trying to
change to XLA format that will take care of this but boss man is in the way.

I can feel your pain. Good luck with this project.

Best wishes Harald