Before Update Botton

[glmleilei]

Hi all,
I have 3 macro importing 3 files, and then another button to process those data.

So, I need a function to enable/disable the button depending on the files have been imported or not.

Please advise. Thanks in advance.

Regards,

Michael

 

[burrina]

You have not given enough information to help.However, it sounds like a simple:

If (Me.SomeCriteria) = (Me.Something) Then
    Me.SomeControl.Enabled = False  ' Or True
End If

HTH