Check Box Enable/Disable Based On Value From VLookup

Hi All

Hope someone can help. I am not good with codes in vba () - the code I have currently added to check box does not work. (Please see attached example)

What I would like the code to do is enable the check box if the value in row 5 is "Y" (on ‘Checklist’ worksheet) and disable if anything else is displayed.

I have seen many threads but the problem is that the value I have in workbook has a vlookup formula and when the lookup cell is changed I would like the check box to automatically enable/disable depending whether a 'Y' is placed or not. - is this possible??

The worksheets are:
- Data - this is where the data is stored, where 'Colours' are assigned to 'Letters'

- Checklists - Vlookup formula in row 5 which looks up the 'Letters' to see which colours are displayed as 'Y' – and shown below is the check boxes.

Hope I have explained this clearly!

Regards.