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" <Pendelfin@discussions.microsoft.com> wrote in
message
news:91FF19AB-A2CA-4DDA-9F6A-CA52D753391E@microsoft.com...
> 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.