Hi,
I don't know why but the Application.ScreenUpdating=False does't work in VBA
Excel in a specific situation (lot of workbook open). I never had any problem
with this before.

Function A:
Dim bValue as boolean
bValue = Application.ScreenUpdating
Application.ScreenUpdating = False'this works
'Treatment
Application.ScreenUpdating= bValue... 'this works: the value return to True

into an other function thereafter, I have the line:
Application.ScreenUpdating = False
after the execution of this line, in the debug box:
debug.print Application.ScreenUpdating
True

When I open a new instance of Excel and open the workbook from the new
instance, it works well. Any idea?

Thank you!
Alex

--
Alex St-Pierre