Pop open form when opening a spreadsheet

[Matrix34]

This will be very simple basic coding to most of you, I'm just experimenting at the moment.

I have created a form which I need to popup whenever my excel spreadsheet opens.

Could someone provide me the code please, I've been trying all sorts.

Cheers

[cbbibleboy]

In a timer, you could have it check for any window with a title "Microsoft Excel", then do whatever. Your code could look something like this:

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long

Dim hwndFound As Long   'The window handle

Private Sub Timer1_Timer()

    'Get the handle of the application if it is open
    hwndFound = FindWindow(vbNullString, "Microsoft Excel - Book1")
    
    If hwndFound Then
        Me.Show
        SetForegroundWindow Me.hwnd
    End If
    
End Sub

[Killer42]

Is this a separate VB program, or is it written as a VBA macro in Excel?

[cbbibleboy]

It's a VB program that runs hidden in the background with a timer. Good question, though.