⟩ I want to show a userform each time my file is opened?
Combine the two solutions above:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
or
Sub Auto_open()
UserForm1.Show
End Sub
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Is there a way to protect the macros I create so people can not see or alter them?
Is it possible to call a macro from the condition true or false side of a worksheet formula? i.e. If(A2="OK",Run macro1,run macro2)?
How can I save a chart as a GIF file?
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?
How can I enter the current date into a cell so it does not change from day to day? When I use the NOW function, it always shows the current date?
I need to determine the difference between two times. If the difference is positive, it works fine. But Excel does not want to display negative time values. Why not?
Is it possible to determine the day of the week for a particular date?
I have a range of time values, but when I try to sum them, the total is never greater than 24 hours?
I have a worksheet that shows total hours and minutes worked, along with the hourly pay rate. When I multiply these vales, I do not get the result I am looking for. What is wrong?
How can I calculate the difference between two dates?
