Working while a macro is running in Excel can be a bit tricky. Here are some tips to help you get the most out of your experience:
When a macro is running, it is best to not interrupt it. This can cause the macro to stop running or even crash your computer. If you must interrupt the macro, use the Stop button on the toolbar.
The status bar is a great way to keep track of what your macro is doing. The status bar will show you the progress of your macro as well as any errors that may occur. To access the status bar, go to View > Status Bar.
There are many shortcut keys that can be used while a macro is running. These shortcut keys can be found in the Help menu. To access the Help menu, press F1 while in Excel.
It is always a good idea to save your workbook before running a macro. This way, if something goes wrong, you will not lose your work. To save your workbook, press Ctrl+S or go to File > Save.