Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Excel 2003 I wrote a code that briefly turns off "Display Alerts"
Application.DisplayAlerts = False Windows("Employee DataBase.xls").Close Application.DisplayAlerts = True The code goes to the "Employee Database" file and closes it (the file the code is in was pulling some data from that file. Now we have Vista and Exel 2007. The file the code lives in and the "Employee Database" file open and work properly in the new version of Excel except I get an error that freezes everything up at the code listed above. When I omit the "DisplayAlerts" code, everything works, but you have to answer the pop-up questions to close "Employee Database". How can I re-write this code? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display Alerts | Excel Discussion (Misc queries) | |||
Display Alerts | Excel Programming | |||
Display alerts | Excel Programming | |||
Display Alerts | Excel Programming | |||
Display Alerts | Excel Programming |