ScreenUpdating, EnableEvents settings

[tiredofit]

If in a single session of Excel, I have two workbooks and in workbook 1 I set ScreenUpdating and EnableEvents to be False, then close it, are the states for workbook2 still set to False?

I'd like to test it but I have found that despite setting ScreenUpdating to False, when I check it in the Immediate window using:

? Application.ScreenUpdating

it still shows True.

Why is that?

 

[MacroAlan]

It sounds like you have not set Workbook 2 to turn off ScreenUpdating