first of all
Workbooks("C:\Documents and Settings\chavispb\Desktop\SALWORKUP\Banded Salary Promo Workup Tool.xlsm").Activate
change it to just the file name, without the extension since this workbook is already open excel will find it as an object
so it should look like this
Workbooks("Banded Salary Promo Workup Tool").Activate
finally when you enter a number to search for, do not enter any leading 0000s
because the way excel evaluates it is as an integer and leading 00000s are automatically stripped off.
so if you are searching for 00054282 for example, you would enter that as 54282, and it will work.
if that gets confusing for the user you can change the cell format to general in column b of the
http://wikisend.com/download/666234/Alpha for SAL Workup.xls
and it will strip out all of the zeros that are displayed.
hope this helps.
if it still does not let me know and I will do the remote