Turn DisplayAlerts Back On

[PhilH123]

Hi All,

I'm sure someone will know how to do this and make me feel really stupid!!

I have an Excel spreadsheet which is to be used as a questionnaire. I hide all toolbars, tabs etc; and turn off alerts.

The thing is I don't want to get the save changes message up when the user closes the application - all data is output to a text file before this stage is reached - but as this will be sent to many different users I don't want to leave any Alerts turned off!

Can someone please help?

Thanks in advance.
Phil.

 

[PhilH123]

And I have just found that DisplayAlerts doesn't affect this anyway, so my problem has just gone sideways!!!

Phil.

 

[PHV]

Have you tried this ?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = True
Me.Saved = True
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PhilH123]

PH,

I still get asked the question, even though I have added 'Me.Saved = True' as the last statement in the BeforeClose event!!

Thanks for the idea though, I'm sure this approach has got to be in the right direction.

Phil.

 

[PhilH123]

PH,

Ignore my last post - I forgot to take an Exit statement out!!

This works great.

Thanks again,
Phil.