ScreenUpdating Stuck on False

[BRich83]

Somehow I managed to set ScreenUpdating = False for the entire Excel application. When I open any excel workbooks the only thing that appears is the tool bars on top because the rest isn't updating. However, if I open up VBA editor and run a quick code,

sub test()
Application.ScreenUpdating = True
End Sub

everything works properly. If I save and close the program and reopen it, or any other workbook, screenupdating = false again.

How do I fix this?

 

[Ziggy12]

You might've entered the false code into book1 which is the template or into personal.xls and somehow its running when excel is opened.

Have a hunt around in the VBA Project window and check out all the modules.