View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] bmorgan02@gmail.com[_2_] is offline
external usenet poster
 
Posts: 3
Default Macro CPU Utilization Issue

I'm using Walkenbach's Progress Indicator form to display the progress
of a fairly complicated macro I've written. It would work fine, except
that when I run it my CPU utilization shoots up to 100% for over 5
minutes and my Progress Indicator/Excel freezes until completion. So
this nice progress indicator I've built in is now basically useless.
Does anyone know a workaround?

Secondly - are Userforms/repainting of forms subject to the
ScreenUpdating=False?

Thanks!

Brad