I would like to place Application.ScreenUpdating = False in a workbook in
such a way that it will have a global effect.
I have approximately 35 worksheets that are calculating variables dependant
on cell contents, applying formats, and several other things. When a set of
data is modified on one worksheet, that sheet "hangs" for a couple of seconds
and then flashes rapidly while the calcs are performed on each of the various
cell ranges.
I would love to avoid having to add the screenupdating variable to each
individual page by calling it from the "This Workbook" item in the Visual
Basic explorer.
1. Is this possible?
2. Can I just use Application.ScreenUpdating = False
Application.ScreenUpdating = True
with nothing in between them?