VBA Code Debug Error

Hi, I have created a macro enabled excel spreadsheet using VBA code to link from one sheet to another with filtered values.

The problem is that when I use the sheet and click in the AH cell in the Opportunities tab I get an error - see Image1.

Image1.jpg

When I click on Debug, it takes me to the VBA - see Image2.

Image2.jpg

There are a couple of things puzzling me; 1 - When I click on the links in the AI cell in the Opportunities tab it works fine, and 2 - my colleague at work never sees the error I get. When he opens the file he is prompted to enable editing and then enable content in Excel (I am not prompted for this).

I have attached an example of the xlsm that I have created.

Any help would be greatly appreciated.

Many thanks,
Steve