Hello Everybody,
Can anyone let me know how to activate Userform when I open the excel file containing that macro?
I have created a Userform with 2 Command buttons. One button to Run the macro and other to close the file. I don't know how to bring the userform when I open the this Excel file. Every time I have to go to VB editor window and run the form from there.
Thanks & Regards,
Prashanth
Can anyone let me know how to activate Userform when I open the excel file containing that macro?
I have created a Userform with 2 Command buttons. One button to Run the macro and other to close the file. I don't know how to bring the userform when I open the this Excel file. Every time I have to go to VB editor window and run the form from there.
Thanks & Regards,
Prashanth