Maybe you could modify your macros so that they check where you are before
continuing:


Option Explicit
sub testme()
if activeworkbook.fullname < thisworkbook.fullname then
msgbox "Not available in this workbook!"
exit sub
End if

'real code here
End Sub

ThisWorkbook is the workbook that owns the code. Activeworkbook is the workbook
that's active <bg.




Bill_S wrote:

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.

--

Dave Peterson