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)