Macro relative to a cell

[almoni]

Hi all,

I've written a macro which executes a program when specific cell is double-clicked.( For example: A1 ).
If I move the contents of the cell to any other position(A1 to B2), A1 is still the cell which
executes a program.

Is it possible to make the macro relative to the cell. In the other words: If I
move the contents of A1 to B2 I want B2 be the cell which executes a program.


On the other hand If you have any simple idea of executing programs with arguments by clicking on a cell?


Thanks all,

Daniel

[mrice]

I guess that you could run the code when selecting any cell and get the code to quickly exit if the cell does not contain the value that you want.

[almoni]

Thanks for your reply.

Actually I would like to manage a list of files in excel.

Every time I click the name a program will be executed.

The problem is that if I need to add or remove a file to/from the list, the macro still points to an original cell.

What I need is:

1. Recent situation: Cell Value of A2 is "File2"
If I click it File 2 is executed
2. Now I move "File2" to A3
I need that if I click A3 File2 will be executed
and not A2!


Thanks again,

Daniel