Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-14-2016, 10:53 AM
OldAl OldAl is offline Excel 2016 Macros running slow Mac OS X Excel 2016 Macros running slow Office 2016
Novice
 
Join Date: Jan 2016
Location: Ridgecrest, CA
Posts: 4
OldAl is on a distinguished road
Default

I don't know specifically what it does. I seems to just avoid sending signals to the screen i.e. leaves them blank. My stuff doesn't have any protect/unprotect commands but does have lots of charts and sort commands. For macros that are just calculations and no charts to update the slowness is not nearly as apparent.
The Mac Excel 2011 has the no-screen-updating built in but doesn't blank out the screens -- it just didn't update anything until it is done with the macros. Much, much Better.
Reply With Quote
 

Tags
macros, vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros are VERY slow to run wxtoad Excel Programming 12 09-09-2014 06:11 PM
Quick Access Toolbar/Macros not running salbergotti Word VBA 1 07-06-2014 06:40 PM
Running Excel from a webpage jimbassett Excel 0 04-22-2014 02:11 PM
Running total in Excel chart jen152638 Excel 0 06-14-2010 05:38 AM
Excel 2003 SP3 bug when running Macros EnricoVenturi Excel 0 09-06-2009 08:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft