Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Forms - Max Me
You could hide the application (and remember to reshow it when your userform is
dismissed). application.visible = false userform1.show .... application.visible = true ..... But then other stuff will be visible instead of excel. Or you could just fill all of excel's window: Private Sub UserForm_Initialize() With Me .Top = Application.Top .Left = Application.Left .Height = Application.Height .Width = Application.Width End With End Sub Sgwapt wrote: Is there a way to manipulate user form to maximize when initialized? I am currently using a default size for all my forms using zoom integer but with different station settings on network environment I noticed they can still see the background. I would like to prevent that ability. Thanks for your help -- George G Quality Director Fox Lake IL USA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms | New Users to Excel | |||
User Forms | Excel Discussion (Misc queries) | |||
user forms | Excel Discussion (Misc queries) | |||
User Forms | Excel Programming | |||
User forms | Excel Programming |