Excel Warning dialogs disappeared

SteveG · May 12th, 2003, 2:23 pm

We have a user that can load up Excel spreadsheets, make changes to it and then when they close down Excel it does not prompt them to save the changes. Does anyone know how you turn back on this warnings, or how they got turned off in the first place. I have already checked the application.displayalerts and this is set to true, is there another VBA command I can try as well. Many thanks Steve.

Student · May 12th, 2003, 8:40 pm

Hi, one possibility I know of is the workbook eventPrivate Sub Workbook_BeforeClose(Cancel As Boolean) Me.Saved = TrueEnd Subwith which excel will discard any changes and not prompt the user for saving.

DavidJN · May 13th, 2003, 10:46 am

Steve,Is this what you are looking for? Application.DisplayAlerts = True

SteveG · May 13th, 2003, 11:32 am

nope I have already tested that option and it is set to true, plus if you set it to false the dialog still comes up and prompts the user to save changes to the workbook.Thanks for the option though, I think it might be just a case of re-installing Excel and seeing what happens as it is only happening on one machine in the office.CheersSteve.

PinballWizard · May 14th, 2003, 12:56 am

Have you checked Tools | Options | Save tab ?Does the file behave similarly on other machines ?Check the MSDN knowledge-base ... might save you from re-installing Office !

SteveG · May 14th, 2003, 6:31 am

ok the problem has been sorted now.The problem was down to a third party addin, when we took the addin out of Excel it all started to work correctly again. Should have spotted this as an odditty earlier.Cheers for all the input.Steve.