I posted the following in the "programming" discussion group but haven't
gotten any replies, so I'm reposting he (I'm desperate)

"OCD Cindy" wrote:

I have a form with several macros on a single tab in an Excel XP worksheet.
Each time the user has an update to this form, they are to add a new
worksheet tab and copy the form from the original tab. is there a way to
copy the macros that automate the form to the new tab? (when I just copy
them, the cell references within are copied so that the macros are applied to
the original sheet instead of the new sheet)