Wolfgang
08-23-2006, 07:43 AM
Good Morning/Evening to you...
Is it possible to remove a module from the current workbook if a certain condition is met?!
Here's the module:
Sub QueryProcess()
'set working directory to this workbook's folder and get file list
*** IF CEll A61000 CONTAINS "EXPIRED..." THAN REMOVE ME ***
If [COUNTA(D4:D100)] = 0 Then
MsgBox "You Did Not Specify Any Search-Criteria..."
Exit Sub
End If
Bea_ausfuellen
FileSearchUF.Show
STS
End Sub
I like to have that module be removed so that the user will not be able to use that routine anymore...
Thank you and best regards,
Wolfgang
Is it possible to remove a module from the current workbook if a certain condition is met?!
Here's the module:
Sub QueryProcess()
'set working directory to this workbook's folder and get file list
*** IF CEll A61000 CONTAINS "EXPIRED..." THAN REMOVE ME ***
If [COUNTA(D4:D100)] = 0 Then
MsgBox "You Did Not Specify Any Search-Criteria..."
Exit Sub
End If
Bea_ausfuellen
FileSearchUF.Show
STS
End Sub
I like to have that module be removed so that the user will not be able to use that routine anymore...
Thank you and best regards,
Wolfgang