ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Preventing screenupdating from modfiied (https://www.excelbanter.com/excel-programming/322530-preventing-screenupdating-modfiied.html)

augustus

Preventing screenupdating from modfiied
 
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

Preventing screenupdating from modfiied
 
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



All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com