Getting workbook and sheet name in UDF

[TimFoley]

I see that application.caller.address will give me the cell reference that accessed my UDF. However, I cannot find a way to get the workbook and sheet names.

My UDFs reside in a .xlam so ThisWorkbook.name returns the .xlam and ActiveWorkbook.name returns the active workbook which is many times NOT the workbook housing the cell containg the UDF.

I realize I could include both as parameters, but this will make it more painful for the endusers, so I was hoping there was a way to get the workbook and sheet names.

Thanks in advance - Tim