Preventing screenupdating from modfiied

[Guest]

Hi,

I'm using Office2003 & WinXP Pro, Visual SOurceSafe 6.0d.

I'm having serious problem with Application.ScreenUpdating.
I cannot set:
Application.ScreenUpdating=False

Is there setting in Excel that can prevent people from modifying
Application.ScreenUpdating?

I had checked the VBA code numerous, and cannot find code which reset
Application.ScreenUpdating back to True. Also the
Application.ScreenUpdating=False is set at the beginning of the module.

Thanks
Augustus

 

[arno]

Hi,

I had checked the VBA code numerous, and cannot find code which reset
Application.ScreenUpdating back to True.

This happens automatically when your code is finished.

arno