Hey RBS,
I figured it out. I have to include the workbook.add line of code in
because the add-in actually kicks in before the blank excel book opens,
and if there are no worksheets it returns the error, then opens the
blank excel workbook, without performing the subroutine.
Thanks,
Jay