PDA

View Full Version : is macro running?



Ago
02-27-2008, 11:17 AM
i have a button on the sheet that starts a macro.
the problem is that you can press the button several times and the macro will run several times and make a big mess.
how can i stop that?
can i find out if the macro count_salary is running?

mikerickson
02-27-2008, 12:32 PM
If you can press the button, the macro is not running.

If re-running a routine will foul the data, you could either add a bit at the start of the macro to test if the sheet is OK to alter or you could have the user answer a "Do you want to do this?" MsgBox.

Bob Phillips
02-27-2008, 12:36 PM
Hide the button at the end of the macro.