Macro setting in Excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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)
 
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
 
Christine

Check the TakeFocusOnClick property is set to False

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