Saturday, January 1, 2011

Full Screen Userform

Private Sub UserForm_Initialize()

    With Application

        .WindowState = xlMaximized

        Zoom = Int(.Width / Me.Width * 100)

        Width = .Width

        Height = .Height

    End With

End Sub

No comments: