Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.office.developer.vba
|
|||
|
|||
HELP: MsgBox takes 99% CPU usage... why?
I got a problem with my Excel macro. It does some calculations then displays
a message box. However the message box is actually displayed before the window maximize so what actually happens is the user sees the minimised Excel blinking in the taskbar. The problem is I have been told this blinking uses 50% of the CPU or almost 100% CPU usage. Is this normal? Is it waiting in a for loop prompt? Public Sub Updates_Off() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub Public Sub Updates_On() With Application .StatusBar = False .ScreenUpdating = True .DisplayAlerts = True .EnableEvents = True .EnableCancelKey = xlInterrupt .Cursor = xlDefault .Calculation = xlCalculationAutomatic End With End Sub Private Sub Workbook_Open() Updates_Off Application.WindowState = xlMinimized Updates_On Response = MsgBox("Test", vbYes + vbCritical, "Template Message") Application.WindowState = xlMaximized Application.Quit End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: MsgBox takes 99% CPU usage... why? | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Excel takes along time to calculate | Excel Worksheet Functions | |||
Edit query takes a long time | Excel Worksheet Functions | |||
Msgbox | Excel Worksheet Functions |