Hi Norman,

Yes, the macro is run from a commandbutton. The only problem now is the
button is from the "Forms" toolbar so it is not an 'ActiveX' control (this
was done so the macro would work on Mac's as well as PC's) -- I can't seem to
access the same Properties that I can with an ActiveX control -- is there a
way for me to access the "TakeFocusOnClick" property of a commandbutton from
the "Forms" toolbar?

Thanks for your help!

Robert

"Norman Jones" wrote:

Hi Robert,

Is the macro run from a commandbutton?

If so, try setting the TakeFocusOnClick property of the button to False.


---
Regards,
Norman



"Linking to specific cells in pivot table"
crosoft.com wrote in
message ...
Hi,

I searched through previous posts but could not find anything that
directly
applies to my case -- I have a client that gets the following error when
they
run a macro on a spreadsheet I created on their laptop with Excel 97 (it
works when they run it on their mainframe which has Excel2000):

"Run-time error 1004 copy method of range class failed"

Is there any quick fix for this without knowing exactly where the macro is
failing (I could find out if necessary -- the problem is I'd have to walk
the
user (who's not very proficient in computers) through this over the phone.

Thanks!

Robert