run time error 1004 for other user
 

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.

run time error 1004 for other user
 

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.