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.

It would help to show the code.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"
m wrote in message
...
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.