There is no way to assign a macro to a cell. However, you can use
either the Change or SelectionChange event procedure to execute
code with a cell is changed or selected, respectively.

See http://www.cpearson.com/excel/events.htm for info.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Pendelfin" wrote in
message
...
How can I assign a macro to a specific cell in an Excel
sreadsheet. I know
theres a way but I cant find the answer. Many thanks for your
help.