Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I've seen and religiously use the oft suggested technique to stop screen flicker/refresh with running macros: application.screenupdating=false your code application.screenupdating=true I have one workbook, however, that merely switching between workbooks will cause this workbook to redraw its selected sheet 3 times! Very annoying. Could it be that its Workbook_Activate routine adds custom menus? Other workbooks don't act that way even when menus are added. I've even gone so far as to include all three: Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual No change. Can anyone shed light on this phenomenon, or offer a solution? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make a splash screen appear first | Charts and Charting in Excel | |||
Active cell moves off the screen | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Hyperlink Screen Tips not cross platform | Excel Discussion (Misc queries) | |||
How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) |