vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
When I run one of my macros, I display a message box at the start to warn the user to close some files before running. When the user clicks OK, the macro continues, but the message box remains. #1 Is there a way of removing this so it doesn't display throughout the run?
Also, #2 if anyone could point me to a good and light procedure to display a macro run time status bar, I would be grateful. I have created a basic one in the past, but it required quite a lot of additional code to be inserted into the original macro. It was also quite non-linear, which made it difficult to reasonably gauge time to completion.
Many thanks,
vcoder
When I run one of my macros, I display a message box at the start to warn the user to close some files before running. When the user clicks OK, the macro continues, but the message box remains. #1 Is there a way of removing this so it doesn't display throughout the run?
Also, #2 if anyone could point me to a good and light procedure to display a macro run time status bar, I would be grateful. I have created a basic one in the past, but it required quite a lot of additional code to be inserted into the original macro. It was also quite non-linear, which made it difficult to reasonably gauge time to completion.
Many thanks,
vcoder