Detect macro's parent workbook or worksheet
 

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.

Detect macro's parent workbook or worksheet
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Conceptor wrote:
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.