screenupdating=false not working

  • Thread starter Thread starter Spencer.Sadkin
  • Start date Start date
S

Spencer.Sadkin

at the beginning of my code i have both
application.screenupdating=false and application.displayalerts=false
yet when running the code a dialog pops up that says "opening" with
the ok and cancel buttons (its a true excel message) which is
dangerous in case a user accidentally hits cancel. anyway to prevent
this? its excel 2007

basicly i loop through a folder open every file and write down a few
values.

thanks
 
I'm seeing that DisplayAlerts isn't captured and I'm using Office 2003. I'm
betting this is related. I was having issues earlier this week with opening
files via code that had macros in them and each file asked me if I wanted to
enable the macro. I had to change the AutomationSecurity to get that to work.

Barb Reinhardt
 
Back
Top