MACROS

[Guest]

I have macros setup in a worksheet with macro buttons set
to run these macros. Everything was running fine until I
saved this worksheet to a different name. Since then when
I click on a macro button I get an error saying that the
new worksheet name could not be found. In the original
worksheet I can see my macros with the correct name. Does
anyone know why this is happening? Also, how can I
save/backup a worksheet with macros somewhere else so this
doen't happen again.

Thanks