MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Minimizing Excel while using VBA...


Posted by Tommy D on January 16, 2002 11:07 AM

Is it possible to code "thisworksheet" to minimize Excel when opening while working thru VBA??


Posted by Tom Urtis on January 16, 2002 11:10 AM

Try this line of code at the beginning of your Open event:

ActiveWindow.WindowState = xlMinimized

Any help?

Tom Urtis

Posted by Tommy D on January 16, 2002 12:27 PM

Works like a charm, thanks (nt)