ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 Alert Messages (https://www.excelbanter.com/excel-programming/319896-excel-2003-alert-messages.html)

Jim Thomlinson[_3_]

Excel 2003 Alert Messages
 
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

Excel 2003 Alert Messages
 
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...b;en-us;827742
Jerry


"Jim Thomlinson" wrote in message
...
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





All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com