Excel 2003 Alert Messages

[Guest]

We are converting from Excel 2000 to Excel 2003. In my testing I have noticed
that 2003 has an alert message if a find and replace does not make any
replacements. This did not occure in 2000. I can modify my code in the
affected spreadsheets using the application.displayalerts so this is not a
problem. What I would like to know is what other surprises can I expect in
terms of new alert messages. I would like to modify my code before I sart
getting complaints from my end users.

TIA

 

[Jerry N]

Jim
If your Excel Xp or 2003 application calls an "unsafe" ActiveX control, you
will get an alert upon opening it. I don't know of any way to get rid of
the alert using VBA code. It can be eliminated on individual computers by
adding registry entries as described in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827742
Jerry