I don't think it has anything to do with the code. Right-click the Form and
click on Properties. Look in the window that opens (lower left corner of the
screen). Look at BackColor, click the down arrow... System? Palette? Does
any of that work for you?


Regards,
Ryan---

--
RyGuy


"ChrisP" wrote:

I have a worksheet which has a button. When the button is pushed it shows a
userform, the userform code calls other sub to run. My problem is that the
userform is not showing up correctly. The title is showing but the inside of
the form is completely white (which is not what I made).

Here is my code:

Button code:
Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

UserForm code:
Private Sub UserForm_Activate()
Call testing
End Sub

Testing code (which is in a Module):
Sub testing()
Workbooks.Open Filename:="\xxx\Template.xls", UpdateLinks:=0
ActiveWorkbook.Close
Unload UserForm1
End Sub

How do I make the middle of the form visible? What am I doing wrong?
Thanks,
Chris P