MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Showing User Form on Startup


Posted by Stan on October 03, 2001 8:21 AM

In my Sub Workbook_Open()I am specifying which sheet to show and also creating a custom menu. At the end of the sub I inserted myUserForm.Show. What I'm trying to do is to have the UserForm on top of the opened sheet. But when I start the application, the UserForm is visible but neither the custom menu or the sheet become visible until I exit the UserForm. How can I get around this problem?

Cheers

Stan


Posted by Stan on October 03, 2001 8:40 AM

Solved - set UserForm ShowModal to False