Alan,

Can you use

Activeworkbook.Worksheets.Add

If not, somewhere along the line you will have to capture the workbook and
save it in a variable.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Alan Beban" wrote in message
...
Bob Phillips wrote:
Workbooks("Workbook1_Name").Worksheets.Add

Thanks, Bob. But the Add-In Sub doesn't know the name of the workbook of
the calling Sub.

Alan