In place of "Application" use "ActiveWindow".

--
Jim Rech
Excel MVP
"Ryan" wrote in message
...
| Steve,
|
| The code that you gave me works almost perfectly. The one problem is that
it resizes the original workbook too. I want it so that Excel stays
maximized but the new workbook is smaller. I will play around with it some
and see if I can figure it out, but if anyone knows how to fix this problem
please post.
|
| Ryan