Hi,
I want to open my userform when my excel is opened and hide the excel behind until the user form closes.
I used
Application. Visible false
Me. Show
It is working but when the excel is opened it shows the excel for a moment and then it is showing userform.
I also tried keeping update links to false. But same thing happened.
How to avoid the workbook shown for a second and show only userform when the excel is opened.
Thank you in advance!
I want to open my userform when my excel is opened and hide the excel behind until the user form closes.
I used
Application. Visible false
Me. Show
It is working but when the excel is opened it shows the excel for a moment and then it is showing userform.
I also tried keeping update links to false. But same thing happened.
How to avoid the workbook shown for a second and show only userform when the excel is opened.
Thank you in advance!