Stop macro from executing multiple times with multiple clicks

Hello. I have a timer that I created for a specific purpose that is activated by a macro assigned button (shape). The problem that I am having is that if the button is clicked more than once while the timer is running the countdown time accelerates. In other words, the number of seconds that it takes off each cycle increases every time the button is clicked. The button sometimes will get clicked an extra time by mistake and I would like to prevent this from impacting the timer. How can I limit the macro from re-firing once it is already running? The code I am currently using is below. Note, there is a bit of noise in it because I actually have the timer running twice per cycle with different times and the times are assigned by cell references along with a delay between the two countdowns. That is why there are also macros with "2" at the end. The ones with no "2" at the end are specific to the first run and the ones with a "2" at the end are specific to the second run. I assume that some additional code will need to be added to the StartTimer macro to achieve what I want to do, but am not 100% sure, thus why I am sharing everything.

Please Login or Register  to view this content.

Hi,

from several obvious solutions one is to just hide the shape at the beginning of the procedure and unhide it at the end …

Thank you for the quick reply Marc. That may work in some cases, but not in mine if it requires hiding columns or rows. If you are referencing hiding the shape itself, I am not familiar with how to do that.

As I explicitly wrote « hide the shape » according to its property Visible, just taking a glance to its VBA help …

Another obvious way is to declare a Static variable in the procedure and to check it in order to see if the procedure is already running …

I am re-posting the code without 2 unnecessary marcos that I just noticed were still there. This may make it simpler to understand.

Please Login or Register  to view this content.

Thank you Marc. I did not know that you could hide the shape, thus why I didn't associate your reply with explicitly hiding the shape. I will explore that further and see if that will work for me. I also like the idea of adding a static variable, so I will explore that more and decide which will work better for me.