Detect macro's parent workbook or worksheet

C

Conceptor

Hi all,

I need to know from what particular workbook, worksheet and cell a given macro function is called from. The call could be made from a worksheet.calculate, a user pressing enter in the cell, or any other mean that would trigger the calculation of the formula in the cell

How can I achieve it

Thanks
C.
 
F

Frank Kabel

Hi
not quite sure what you're trying to do but have a look at
application.caller
 
Top