Hi Anna

You can use this event in the userform

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Anna B" wrote in message ...
Sorry, let me try this again. I have a userform that I want to have open
when the workbook opens. I have managed to do this, but the form only fills
up part of the screen. Is there a way to make it fill up the whole screen?
Thanks for your help.

"Anna B" wrote:

I have a user form that I want to have open when