Leith,

Thank you for the URL however, I am an amature at best when it comes to
VB Code...Would you mind telling me exactly what the code is? I tried
to make sense of it on my own but got lost once I got into
"DevM.dmPelsWidth = 1024 'ScreenWidth - could also be 800, etc"...Much
appreciated. Thanks man!

Leith Ross wrote:
Hello Shaka215,

You will need to use the Windows API to accomplish this. Look at this
post at "thescripts" community. It is very well written macro.

The URL is http://www.thescripts.com/forum/thread13907.html

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=561921