View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Error 1004 Display Alerts

JT,

It is likely that you have a reference that your user lacks - often, different versions of Office
produce this type of result.

Have the user go into the VBE and check the references of the file for any missing references.

HTH,
Bernie
MS Excel MVP


"JT" wrote in message
...
I sent my macro to a field user. When I run it, it works as expected. When
they use it, they get the following error message:

Runtime Error 1004

Method DisplayAlerts of object Application failed

Does anyone know what causes this on one machine but not the other? We both
have IE 6.0.

Thanks for the help.....
--
JT