I found how to do what I wanted. I did not catch it the first time but when creating the macro there is an option that allows you to save the macro in one of three places: Personal file, current workbook, or new workbook. It apparently was defaulting to personal.xls so I recreated it saving it in the current workbook. Thanks, B2W