![]() ![]() To disable displaying page breaks use this line of code: ActiveSheet. Last, your VBA code can be slowed down when Excel tries to re-calculate page breaks (Note: not all procedures will be impacted). If your workbook contains events you should usually disable events at the beginning of your procedure: Application.EnableEvents = False There are several other settings to play with to improve your code speed.Äisabling Automatic Calculations can make a HUGE difference in speed: Application.Calculation = xlManualÄisabling the Status Bar will also make a small difference: Application.DisplayStatusBar = False Sub Syntax Dim strMsg strMsg 'Shutdown.vbs, Version 1.10'
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |