Unable to run macro - get an error message

Hello,
I have added some VBA code to my excel file, but when I click on the command button, I get an error message that reads "Cannot run the macros 'VBA_Code2Find_Data.xlsm!SearchBox. The macro may not be available in this workbook or all macros may be disabled.
I have turned on all macros with "Enable all macros", I have the vba code added into the file, but nothing works...
I am trying to enable a search of information in the table below, using either the Name or Address. The final table will have about 4000 rows and can be searched using either option. Some words in Name are common, such as Hall, Park and can fetch over a 100 rows in results.
I would appreciate help to fix this error.
Cheers