Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - Prompt for save on exit.
- Thread starter odinfire
- Start date
If your workbook has changed, Excel will automatically ask if you want to save.
If you want to switch off Excel asking whether to save a changed book, and exit without saving instead, then you need to program some VBA into the Workbook_BeforeClose event, to change the attributes of the book, so as to not trigger the automatic question. The code would be:
ThisWorkbook.Saved=True
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
If you want to switch off Excel asking whether to save a changed book, and exit without saving instead, then you need to program some VBA into the Workbook_BeforeClose event, to change the attributes of the book, so as to not trigger the automatic question. The code would be:
ThisWorkbook.Saved=True
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Thread starter
- #3
Actually, what's happening is Excel is closing without prompting the user to save. Example: User opens a new spreadsheet, types something into the spreadsheet, closes the window, and no prompt is displayed asking to save the changes.
I need this prompt to be "re-enabled". As a side note, when I log in with a new user profile, renamed old profile to USERNAME.bak, and I take the same steps above, Excel does prompt to save. Hence, this is an issue w/the profile, and not so much with Excel. Or at least that is my hypothesis
(Not very scientific, I know!)
Thanks!
I need this prompt to be "re-enabled". As a side note, when I log in with a new user profile, renamed old profile to USERNAME.bak, and I take the same steps above, Excel does prompt to save. Hence, this is an issue w/the profile, and not so much with Excel. Or at least that is my hypothesis
(Not very scientific, I know!)Thanks!
Could be calculation turned off with the tickbox not checked to recalc on close....check your calculation settings under Tools>Options
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Failing that, try Help / Detect and Repair.
Regards
Ken............
----------------------------------------------------------------------------
![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
It's easier to beg forgiveness than ask permission![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
----------------------------------------------------------------------------
Regards
Ken............
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission----------------------------------------------------------------------------
- Status