ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Screenupdating is always true (https://www.excelbanter.com/excel-programming/304678-screenupdating-always-true.html)

Petro[_2_]

Screenupdating is always true
 
Hey,
the coding is:
....
application.screenupdating = false
....

but in the time when the macro is working, screen is
always updated. When I have a look with debugger I can see
that after the statement application.screenupdating =
false the characteristic is true and I can't change it.

Any idea ?

Regards
Petro

Vic Eldridge

Screenupdating is always true
 
Hi Petro,

I seem to remember that the programmatic use of the Solver AddIn
can affect the state of Application.Screenupdating.
Could that be the problem here ?

Regards,
Vic Eldridge


"Petro" wrote in message ...
Hey,
the coding is:
...
application.screenupdating = false
...

but in the time when the macro is working, screen is
always updated. When I have a look with debugger I can see
that after the statement application.screenupdating =
false the characteristic is true and I can't change it.

Any idea ?

Regards
Petro



All times are GMT +1. The time now is 08:05 PM.

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