Loading a Form Automatically When Excel Starts

Ben1972 · December 3rd, 2010, 12:42 AM

Hello Everybody,

I'm new to these forums (and VB/VBA) so please bear with me if I'm not doing this correctly. I've designed an application that runs on a form (in vba) but I don't want anyone to see my code, I just need to activate the form automatically. Is there a way of doing this? A friend of mine suggested that I port my code to VB6 and then save it as an executable but this is too much work for me cuz there'll be a lot of compatibility issues etc.

Currently, I run the excel file and then press 'ALT' + 'F11' followed by 'F5' to activate the form. However this means that anyone that does this can view the source code and i understandably don't want that. Is there an Excel switch that can do that, or some Add In? Btw, I know very little about add ins.

I look forward to reading your responses.

Cheers,
Ben.

JP · December 8th, 2010, 12:33 PM

Save the workbook as an add-in, but you'll need to write the code that automatically runs the form. Something like

Code:

Private Sub Workbook_Open()
  Dim myForm As myForm ' or whatever your userform is named
  Set myForm = New myForm
 
  myForm.Show
End Sub

Once you save the workbook as an addin, and install it, the code runs every time Excel (actually, the addin) opens.

HTH