Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a clean way of running a macro?
I just finally got my macro just the way I wanted, I could not have done it without a lot of help from this forum, thank you very much. Right now I have many processes going when the macro runs, sometimes it handles a lot of data so it can take awhile. I was just wondering if there is a cleaner way of running it, maybe having it minimize and a window coming up saying please wait or something so that you do not really have to see all of the steps that are going on in the background. If anyone has any tips that would be great. Thanks again! ~J -- nbaj2k ------------------------------------------------------------------------ nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480 View this thread: http://www.excelforum.com/showthread...hreadid=566609 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a clean way of running a macro?
Type this at the beginning of your macro:
Application.ScreenUpdating = false and this at the end Application.ScreenUpdating = True Msgbox("Macro completed successfully") "nbaj2k" wrote: I just finally got my macro just the way I wanted, I could not have done it without a lot of help from this forum, thank you very much. Right now I have many processes going when the macro runs, sometimes it handles a lot of data so it can take awhile. I was just wondering if there is a cleaner way of running it, maybe having it minimize and a window coming up saying please wait or something so that you do not really have to see all of the steps that are going on in the background. If anyone has any tips that would be great. Thanks again! ~J -- nbaj2k ------------------------------------------------------------------------ nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480 View this thread: http://www.excelforum.com/showthread...hreadid=566609 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a clean way of running a macro?
perfect, just what I was looking for, thanks! ~ -- nbaj2 ----------------------------------------------------------------------- nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648 View this thread: http://www.excelforum.com/showthread.php?threadid=56660 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clean Macro that WORKS... | Excel Worksheet Functions | |||
Text Clean-up Macro | Excel Discussion (Misc queries) | |||
CLEAN function - macro?? | Excel Worksheet Functions | |||
"clean up" after running a program in Excel | Excel Worksheet Functions | |||
Clean Up Background While Running Macro | Excel Programming |