run time error 1004 for other user

G

Guest

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.
 
B

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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '1004' 5
Run-time Error '1004' 1
Ignore macro run time error 4
runtime error code 1004 1
Excel 2007: Help creating a macro that will run Solver? 3
Run-time error '1004': AutoFill method of Range class failed 2
Run-time error '1004': AutoFill method of Range class failed 10
Run-time error '1004' 8

Top