Look under macro … there will be MsgBox command. (this is the message that pops up)
Try commenting out the MsgBox command.
You then also need to adjust accordingly the corresponding Event/Cancel response to the pop up.
I have Excel 2007 (but Excel 2000 should work similarly)
How about adding …
Application.DisplayAlerts = False
Application.DisplayAlerts = True