Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
lpj
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Prompt to save on exit. Fenris Excel Discussion (Misc queries) 0 November 21st 05 06:11 PM
Excel 2003 doesn't prompt to save on exit? Mole Chaser Setting up and Configuration of Excel 4 October 29th 05 03:21 AM
Excel 2003 doesn't prompt to save on exit? Alan Cannon Setting up and Configuration of Excel 1 October 23rd 05 11:02 PM
AutoSave: How can I get it to save every 5 minutes & NO prompt? Valerie Excel Worksheet Functions 1 September 27th 05 10:53 PM
Save prompt for Excel 2003 Adrastos Setting up and Configuration of Excel 1 February 6th 05 08:54 PM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"