Microsoft Excel Question: Download Questions PDF
I want to show a userform each time my file is opened?
Answer:
Combine the two solutions above:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
or
Sub Auto_open()
UserForm1.Show
End Sub
Private Sub Workbook_Open()
UserForm1.Show
End Sub
or
Sub Auto_open()
UserForm1.Show
End Sub
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Is there a way to protect the macros I create so people can not see or alter them? | I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1? |