View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre Laporte Pierre Laporte is offline
external usenet poster
 
Posts: 7
Default What workbook is calling the function

I wrote a function that resides in an addin.

In the function I need to know what workbook is calling the function. It's
not the ActiveWorkbook, as the function may be called from a Workbook that
is dependant on the calling Workbook.

So the question is how do I determine the workbook that is calling the
function ?

Tks