Hi Brian,
It seems that the macro name isn't the issue. I think you need to
change the way you are referencing the worksheets or workbook in your
macro. I think if you post the code someone will be able to assist.

Dan