Can you help me understand what I'm missing here? In D6 I have data validation with numbers. When I double click on D6 I want the word "Works" added to cell H6. All this works fine with the macro below.
As soon as I password protect the sheet I can't get the double click macro to run. When double clicking D6 I just get the spinning wheel and no action. If I hit escape the spinning wheel stops, but still no action.
If I remove the data validation from D6 the code runs fine even protected. I feel I've missed something obvious, but I can't see it.
Please Login or Register to view this content.