MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problem with userform as a menu


Posted by Mikael on July 12, 2000 12:01 AM

I have a workbook that only includes a userform as a menu. It is meant that when I click a button on that menu it unloads and start a another workbook containing a new userform from where you can do several commands. When I exit the workbook I opened and activate the menuworkbook I would like that the menu userform starts. Is there a solution to this?? I have tried with userform. show under workbook_activate but it wont work when using macro, but manually yes...

Thanks in advance

Best Regards,
Mikael


Posted by AB on July 13, 0100 6:46 AM

Just add the following code to the "ThisWorkbook" object of the workbook to be opened.

Private Sub Workbook_Open()
UserForm1.Show
End Sub


-Aaron :)