Problem Unloading Form in Activex DLL

////In Activex Class module i have the following code

Option Explicit
'Class constant declarations follows
'SetWindowLongA API constant
Private Const GWL_HWNDPARENT As Long = -8
'Object reference to the calling Excel Application
Private mXlApp As Excel.Application
Private mlXLhWnd As Long
'Class DLL Declarations
Private Declare Function FindWindowA Lib "user32" _
        (ByVal lpClassName As String, _
    ByVal lpWindowName As String) As Long
                     

Private Declare Function SetWindowLongA Lib "user32" _
                        (ByVal hWnd As Long, ByVal nIndex As Long, _
                          ByVal dwNewLong As Long) As Long
                         
'Class property procedures
Public Property Set ExcelApp(ByRef XlApp As Excel.Application)
Set mXlApp = XlApp
'Get the window handle of the excel application as soon as it passed
mlXLhWnd = FindWindowA(vbNullString, mXlApp.Caption)
End Property
'Class Event Procedure
Private Sub Class_Terminate()
Set mXlApp = Nothing
End Sub
Public Sub ShowForm()
Dim frmform As Form1
Set frmform = New Form1
Load frmform
'parent the form window to the excel application window
SetWindowLongA frmform.hWnd, GWL_HWNDPARENT, mlXLhWnd
frmform.Show vbModal
Unload frmform
Set frmform = Nothing
End Sub

///in Form ActivexDll i have a command button

sub commandbutton1_click
unload form1
form1.hide
end sub

///in excel button i have
sub  MyVb6Form_Click
Dim clsform As project1.Class1
Set  clsform  = New project1.Class1
Set  clsform .ExcelApp = Application
 clsform .ShowForm
Set  clsform  = Nothing
end sub

>>unload form1
>>form1.hide

Yes, you unload the form, and then you re-load it when you tell it to Hide.  What are you trying to do here?  If really unloading, then just use the Unload line.  If you only want to Hide, use only the Hide line.

Hi AzraSound
That didn't work
When i have just unload form1 then it did nothing still form visible
when i have just form1.hide still have runtime error 402

if i say me.hide i have no problem but form1.hide gives me an error402 why is it so?

B/c the first time you load it you created an instance of it called frmForm.  When you refer to Form1, you are referring to the default instance, so this is not the same as frmForm.  They are two separate instances, and thus, would result in two separate forms.  So either use Form1 everywhere, or declare frmForm globally and use it everywhere.

its not allowing me to declare a
global frmform as form1 in class module

Hi Azra i found what the problem is but not the solution
my Button in the form is not throwing a click event

Perhaps this is something related to the setWindowLong api you are using.
Try to use SetParent.