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?

The ScreenUpdating property is in effect from the time it is set
until control returns to Excel -- that is, all VBA code stops
running. It doesn't matter if the code following ScreenUpdating =
False is in one or more procedures.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fleone" wrote in message
...
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?

Chip,
Thanks for the information, I think I understand what you are saying.
Just to clarify: If I place Application.ScreenUpdating = False in the first
sheet of my workbook and then Application.ScreenUpdating = True in the last
page of my workbook, all included pages should not show any of the actual
calculations that are occuring?

Thanks,
Frank

"Chip Pearson" wrote:

The ScreenUpdating property is in effect from the time it is set
until control returns to Excel -- that is, all VBA code stops
running. It doesn't matter if the code following ScreenUpdating =
False is in one or more procedures.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fleone" wrote in message
...
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?