Userform sometimes run and somtimes not when workbook opens

[Malhotra Rahul]

Hi, I have created a UserForm1 and i have put as show when workbook opens and close. But sometimes it runs and sometimes not. I want to make compulsory run the UserForm1 when when workbook opens and close.

Your support would be appreciated.

 

[My Aswer Is This]

Show us the script you are now using.

 

[Malhotra Rahul]

Private Sub Workbook_Open()
UserForm1.Show
End Sub

 

[Malhotra Rahul]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
UserForm1.Show
End Sub

 

[My Aswer Is This]

Before close should look like this:
Unload UserForm1

 

[Malhotra Rahul]

Yes it should look like this but i want to show it while closing the workbook.

 

[My Aswer Is This]

I used your script on close and it worked for me.