Results 1 to 15 of 15

Thread: Excel workbook activation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Dear John,

    thanku 4 repling, but the problem is not solved. I m using office XP.

    My form name is "Rules" (userform)

    While...

    Private Sub UserForm_Initialize()
    Dim hWnd As Long
    hWnd = FindWindow(vbNullString, Rules.Caption)
    SetWindowLong hWnd, -16, &H20000 Or &H10000 Or &H84C80080
    Userform1.Show False
    End Sub
    I get runtime error="424" telling object required.
    awaiting..
    Last edited by Airborne; 03-17-2005 at 03:00 AM. Reason: Added Wrap[VBA]tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •