Sub Workbook_Open??

Posted by zen on June 27, 2001 2:40 AM

i have this code

Private Sub Workbook_Open()

Application.WindowState = xlMinimized
show_Userform1

End Sub

how dow i then show the user form without cicking the appication on the start up bar

cheers zen

Posted by Dax on June 27, 2001 3:20 AM

As long as you're using Excel 2000 onwards just show the form as vbModeless i.e.

UserForm1.Show vbModeless

Regards,
Dax.

Posted by zen on June 27, 2001 6:07 AM

i'm using xl97, which know you can't have modeless forms in (although i have seen a workaround for this, but couldn't download the 6mb file). is there a piece of code that could tell windows (nt4) to activate excel on the Taskbar. If you do it manually it only brings up the form (what i want).

zen