You can run a macro in a function, but it will not be able to change anything in the Excel environment so its use is limited. This
restriction is only if the function is called from a worksheet formula, directly or indirectly.
Look at Event Procedures:
http://www.cpearson.com/excel/events.htm
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"A.Niaki" wrote in message ...
|I want to run instantly a macro when value of a cell is changed (the value of
| this cell is being control by a user function). It means "Is it possible run
| a macro inside of a function?"