how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit
how do i minimize/maximize a workbook from vba? I want to minimize it
durring processing to speed things up a bit |
Hi Daniel,
What you want to do is turn off screen updating and turn off calculation. Slow Response, Memory Problems, and Speeding up Excel Macros run Slow (#slowmacros) http://www.mvps.org/dmcritchie/excel...htm#slowmacros Proper, and other Text changes -- Use of SpecialCells Some notations on the above code, and use of Special Cells (speed and efficiency considerations) « (#notations) http://www.mvps.org/dmcritchie/excel....htm#notations --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Daniel" wrote in message ... how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit |
And you've got another response at your other post in .excel.
Daniel wrote: how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit -- Dave Peterson |
All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com