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" <softwareengineer98037@yahoo.com> wrote in message news:OL4vvWChFHA.272@TK2MSFTNGP15.phx.gbl...
> 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

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" <softwareengineer98037@yahoo.com> wrote in message news:OL4vvWChFHA.272@TK2MSFTNGP15.phx.gbl...
> 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