Load form when workbook opens

  • Thread starter Thread starter melton9
  • Start date Start date
M

melton9

Its been a while since I've worked in excel. How do I automatically
load a form when the workbook opens?

Thanks
 
Right-click on the Excel logo at left end of menu bar.

Select "View Code".

Copy/paste this into that module.

Private Sub Workbook_Open()
Userform.Show
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Merge Multiple workbook sheets into one workbook 0
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel 2003 automatic calculation all worksheets except one 3
Close form automatically upon opening workbook 2
User Form - how to load it 4
personal.xlsb not loaded when excel is called by 3rd party applica 1
Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8

Back
Top