Hello

I want to set Screenupdating = False before saving, because i've got 12
sheets with aprox. 1000 rows, and i see the sheet changing while saving.

I did like this and it dosent work:

Private Sub Workbook_BeforeSave()
Application.ScreenUpdating = False
End Sub


How do i turn on Screenupdating after saving ?


Kind Regards

Claus