Daniel Popa
Automotive
- Sep 23, 2016
- 19
Hello everyone.
I am working on a VBA macro toolbar that would have tabs and buttons for various macros. My only problem is that I feel like I am missing something.
Currently, at the end of each macro, I have "Unload Me" to let the macro run and close the toolbar window. Without this command you could press as many macro buttons as you want but they will only run after you close the window (using "Unload Me" again).
Is there a way of making the macros run immediately after clicking the button without closing the toolbar window?
Thank you.
I am working on a VBA macro toolbar that would have tabs and buttons for various macros. My only problem is that I feel like I am missing something.
Currently, at the end of each macro, I have "Unload Me" to let the macro run and close the toolbar window. Without this command you could press as many macro buttons as you want but they will only run after you close the window (using "Unload Me" again).
Is there a way of making the macros run immediately after clicking the button without closing the toolbar window?
Thank you.