run time error 1004 for other user

[siobhan_roche]

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.

 

[Bob Phillips]

It would help to show the code.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"(e-mail address removed)"