Macro setting in Excel 2002

[Christine]

I've set up some macro in XP version, however, when that Excel file is read
under Excel 2000, there are bugs message pops up. How can I resolve this
problem??

 

[Nick Hodge]

Christine

It's never a good idea to set something up in a later version and expect it
to run in an earlier one. I suspect you have used something that doesn't
exist like coloured tabs, or similar.

We'd need to see the resulting code to be able to diagnose further

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Christine]

Dear Nick,
"Run-time error "1004". PasteSpecial method of Range class failed". We have
set a combo box for a pick up list. When I select 1 item, the macro will
run. Would this be the problem?
Best Regards,
Christine

 

[Nick Hodge]

Christine

Check the TakeFocusOnClick property is set to False

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)