Hi,

Can anyone help. I have recorded a macro in ExcelXP - a protected worksheet
that uses code to unprotect, run the macro and then re-protect the sheet.
This works fine on my machine, but when I send out to another user she
encounters a run time error 1004. The macro still performs the task for her,
but she gets the error message at the end. She also has Excel XP, what can I
put the in code to eliminate the error message when she clicks the macro
button?

Thanks for your time in advance.