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