VB For Applications with Excel

[mattmc97]

Hello all,

I am sure this gets asked alot so I am sorry but I can't find help elsewhere.

I am trying to make a small conversion program using the built in visual basic that comes with Office 2000.

I have made the conversion program on a form using Excel -> Macros -> Visual Basic editor, which takes me to the visual basic editor. I created it, de bugged it, and ran the program and everything works fine.

I am now trying to leave the Visual Basic Constructer View and put the form on to my worksheet in excel.

I am not using any part of Excel so if I can make the form work independently that would work as well.

I have saved it, tried to compile it, but cannot figure out how to get it over to the worksheet.

Thanks in advance.

mattmc

[Bruce Fox]

Something like:

Private Sub Workbook_Open()
 
    Application.Windows("Book1.xls").WindowState = xlMinimized
    frmMain.Show
 
End Sub