Suppress Saving Dialog

[Kindrex]

Hi guys

I hope you can help as I have been scratching my head a bit!

I have code which opens, updates, saves then closes two different work books. I already have used the below snip to stop the screen flicker but i also want to stop the saving file dialog from appearing.

This is to prevent the user accidentally hitting cancel. Any ideas?

 Application.ScreenUpdating = False
'All other code
Application.ScreenUpdating = True

I have tried DisplayAlerts with no joy also..

 

[Yongle]

Are you using workbook event procedures? Difficult to tell what is going on without seeing all the code. How about posting it?
Application.DisplayAlerts does work - seeing your code in full will help us explain why it is not working for you