ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   no prompt for saving after making changes (https://www.excelbanter.com/excel-discussion-misc-queries/130085-no-prompt-saving-after-making-changes.html)

Dan S

no prompt for saving after making changes
 
Excel (2003 on XP o/s) is not prompting to save changes to a workbook that
changes were made to. I can create a new workbook, type a few letters into a
cell then close it witout it asking to save the changes.

Dan

FSt1

no prompt for saving after making changes
 
hi,
Sounds to me like display alerts has been turned off. not sure....wild guess.
try running this macro....

Sub macDAT()
Application.DisplayAlerts = True
End Sub

if that don't fix it, i'm stumped too.
Regards
FSt1

"Dan S" wrote:

Excel (2003 on XP o/s) is not prompting to save changes to a workbook that
changes were made to. I can create a new workbook, type a few letters into a
cell then close it witout it asking to save the changes.

Dan



All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com