You might find the scroll method better than activating Range("A1") of the
display sheet.

Private Sub Workbook_Open()
Sheets(4).Activate 'Be sure there is a sheets(4)
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
ActiveSheet.Range("A1:Z60").Interior.ColorIndex = 5
UserForm1.Show
End Sub


This will avoid the highlighted cell within the window if you have place the
cursor off screen.



"Ken Warthen" wrote in message
...
In the workbook.open event of an Excel spreadsheet I load a userform. Is
there anyway to display the userform before any of the worksheets load or
display? I'd like the end user to only see the userform and no
worksheets.

Ken