Application.ScreenUpdating will always show True in the debug window. But that shouldn't alter the way it works when a routine / function is run. To evaluate this better, can you post a sample file which replicates the scenarios you explained above?