Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdate
hi all is there any way to make a
Workbook.ScreenUpdate or a WorkSheet.ScreenUpdate instead than a Application.ScreenUpdate ??? ty !! paolo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdate
Hi
No I don't think so. But what would you use it for ? Usually you turn off screenupdating at the start of the macro and then turn it on again before End Sub. Regards, Per On 17 Jan., 03:48, pls123 wrote: hi all is there any way to make a Workbook.ScreenUpdate or a WorkSheet.ScreenUpdate instead than a Application.ScreenUpdate ??? ty !! paolo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdate
hi im trying with
thisWorkbook.screenUpdating = false and it works..now im make test for cpu usage, with or without.. i need for multiple pages open simoultaneously...making tests.. with application.screenupdating there is continuous flickering with worst cpu usage, because each page makes change it down and up every cycle of computation.. bybyyy "Per Jessen" wrote: Hi No I don't think so. But what would you use it for ? Usually you turn off screenupdating at the start of the macro and then turn it on again before End Sub. Regards, Per On 17 Jan., 03:48, pls123 wrote: hi all is there any way to make a Workbook.ScreenUpdate or a WorkSheet.ScreenUpdate instead than a Application.ScreenUpdate ??? ty !! paolo |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdate
Screen flicker is usually caused by selecting different books, sheets, cells etc Selcting anything is rarely required when using Vba/macros. If you post your code it probally can be improved -- mudraker If my reply has assisted or failed to assist you I welcome your Feedback. www.thecodecage.com ------------------------------------------------------------------------ mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51411 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdate
hi mud !!..
i have no "selects" i my vba code by longtime !!!!! ;))) with Application.ScreenUpdate = false, i notice a cpu overwork in my multiple open workbook with looping macro... if i use workbook.screenupdating = false ther is no flickering at all.. but i don know if it is active... what do you think ?? "mudraker" wrote: Screen flicker is usually caused by selecting different books, sheets, cells etc Selcting anything is rarely required when using Vba/macros. If you post your code it probally can be improved -- mudraker If my reply has assisted or failed to assist you I welcome your Feedback. www.thecodecage.com ------------------------------------------------------------------------ mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51411 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ScreenUpdate Usage | Excel Programming | |||
ScreenUpdate Usage | Excel Programming | |||
Overriding ScreenUpdate function | Excel Programming | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel | |||
Unwanted freezed screen cause by screenupdate = false | Excel Programming |