I am running excel under office 365 with Windows 10 Enterprise
I am trying to learn how to create a program that will run code automatically (without the use of a button) when a cell's value changes. I found a tutorial on youtube ( https://www.youtube.com/watch?v=FgT0V4XyxEY ) that did this however when I follow completely I get different results.
I have created an excel spreadsheet that has a form control button that toggles cell A1 between -1 and +1. The module should change cell C1 Red when it A1 is -1 and Green when A1 is 1.
When I come to run the code to test however I get a Macro window asking me which macro to run as shown below
I have already set the Macro settings in the trust centre correctly (I believe)
The file is saved in a trusted location - can anyone tell me what I'm doing wrong to get rid of this Macro window please?