How do I make my macro run no matter what sheet I'm on in the workbook. I
don't want to put it in my personal.xls. Rather I just want it specific to
this one workbook, but able to run from any sheet. I tried naming it 'Public
Sub Add_New_Person' and placed it in the ThisWorkbook module but it won't run
when I'm in a sheet in the workbook.

Thanks.