View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Elsom Darren Elsom is offline
external usenet poster
 
Posts: 7
Default Calculate on Status Bar causing VBA to run very slow


I have a workbook which has exceeded Excels limit of 65,536 dependencies.
Consequently I have the 'Calculate' message on the status bar. This does not
pose any problems. However, if the user executes some VBA code, the length
of time time taken to execute can be several minutes for code that can
normally executes in seconds.

Is there a way to force a recalc (F9 or alt+ctrl+F9) and then instruct VBA
to execute procedures without being slowed down by Excel?

Or have I interpreted incorrectly what Excel/VBA is doing?

Any help will be greatly appreciated.

Kind regards,

Darren.