Application.DisplayAlerts in IE
OK, I have been coding in VBA for a few months now, and have use "Application.DisplayAlerts" to supress error messages when deletin sheets. Now, several excel files I have authored for my work have bee moved from the internal lan to a webserver. So, when people click o the links, the Excel files are opened via a browser window shell. The problem: for some reason (IE 6.0, 5.5, 5.0) won't allow th "Application.DisplayAlerts" property to be altered. MS help site sai this was only a problem with IE 3.0, but I have found it still to be problem. I am deleting as many as 12 sheets, and it is unthinkable t ask my users to click "Delete" 12 times as the error messages rol through. Any ideas? Please help... Scoobydeu - scoobydeu ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message581929.htm |
Application.DisplayAlerts in IE
Fix your system clock.
-- Regards, Tom Ogilvy "scoobydeux" wrote in message ... OK, I have been coding in VBA for a few months now, and have used "Application.DisplayAlerts" to supress error messages when deleting sheets. Now, several excel files I have authored for my work have been moved from the internal lan to a webserver. So, when people click on the links, the Excel files are opened via a browser window shell. The problem: for some reason (IE 6.0, 5.5, 5.0) won't allow the "Application.DisplayAlerts" property to be altered. MS help site said this was only a problem with IE 3.0, but I have found it still to be a problem. I am deleting as many as 12 sheets, and it is unthinkable to ask my users to click "Delete" 12 times as the error messages roll through. Any ideas? Please help... Scoobydeux -- scoobydeux ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message581929.html |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com