Issues for defined name when double clicking

[starlev]

I have the following code that when I perform a double click on the cell it performs a macro.

It worked pretty good when I had a
If Target.Address = "$T$21" Then

However I replace the cell reference with a defined name reference and it's not working correctly.

Here is the new code for the double-click event:

Please Login or Register  to view this content.

Please advise what I'm doing wrong

[gmr4evr1]

I believe the range for target address has to be a cell address or a sheet name with the cell address.
What is "Get_file_contains_photos_instructions"?

[starlev]

"Get_file_contains_photos_instructions"
is a cell inside the worksheet which I gave a defined name

[gmr4evr1]

Can you attached a desensitized workbook with the code you are using?

[jaslake]

Hi starlev

See if this works...

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[starlev]

Thank you very much for your help it works.
I tried


If Target.Address = Range("Get_file_contains_photos_instructions").Address Then

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.