software

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)

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