Shameem Khan
New Member
- Joined
- Aug 9, 2020
- Messages
- 13
- Office Version
- 2013
- Platform
- Windows
I am trying to open a Userform without opening excel application. After some searching, I found the codes to do that. It is working fine, however the Excel window always opens before it hides. Is there anyway to avoid flashing of the excel window so that only the userform shows up and nothing else. I have set the following code inside ThisWorkbook object in Excel VBA.
Private Sub Workbook_open()
Application.Visible = False
Application.ScreenUpdating = False
Uf_Randomizer.Show vbModeless
End Sub
Please help, Thanks in advance.
P.S- I am new to this
Private Sub Workbook_open()
Application.Visible = False
Application.ScreenUpdating = False
Uf_Randomizer.Show vbModeless
End Sub
Please help, Thanks in advance.
P.S- I am new to this