Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save prompt for user exit, but no save prompt for batch import?
Hi - I have a workbook that users manually enter data in, then this file is
imported into an application (batch processing).. i've been able to disable the save prompt while the import process, but then this means my users won't have this prompt when exiting the spreadsheet, and we prefer them have this feature.. is there anyway to get both things i am looking for - 1) users be prompted when exiting out of spreadsheet 2) during import process - avoiding the save prompt. currently i have in my workbook_before close function: ActiveWorkbook.Saved = True Thanks! lpj : ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
save prompt for user exit, but no save prompt for batch import?
Maybe these will help......
Application.DisplayAlerts = False 'shuts off the pop-ups Your code here........... Application.DisplayAlerts = True 'turns things back to normal Vaya con Dios, Chuck, CABGx3 "lpj" wrote: Hi - I have a workbook that users manually enter data in, then this file is imported into an application (batch processing).. i've been able to disable the save prompt while the import process, but then this means my users won't have this prompt when exiting the spreadsheet, and we prefer them have this feature.. is there anyway to get both things i am looking for - 1) users be prompted when exiting out of spreadsheet 2) during import process - avoiding the save prompt. currently i have in my workbook_before close function: ActiveWorkbook.Saved = True Thanks! lpj : ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Prompt to save on exit. | Excel Discussion (Misc queries) | |||
Excel 2003 doesn't prompt to save on exit? | Setting up and Configuration of Excel | |||
Excel 2003 doesn't prompt to save on exit? | Setting up and Configuration of Excel | |||
AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel |