I IKHAN Member Jul 18, 2012 #1 Hi, Have a command button on my excel sheet,Looking for a macro to click on command button every 30 minutes. Help is really appreciated!!!
Hi, Have a command button on my excel sheet,Looking for a macro to click on command button every 30 minutes. Help is really appreciated!!!
SirJB7 Excel Rōnin Jul 18, 2012 #2 Hi, IKHAN! Could you elaborate it a bit more? Do you mean you want to execute a macro every 30 mins? Regards!
Hi, IKHAN! Could you elaborate it a bit more? Do you mean you want to execute a macro every 30 mins? Regards!
Luke M Excel Ninja Staff member Jul 18, 2012 #3 Rather than literally clicking the command button, you can just call the macro that the command button is connected to. Check out the OnTime method to schedule a repeating task. http://www.cpearson.com/excel/OnTime.aspx
Rather than literally clicking the command button, you can just call the macro that the command button is connected to. Check out the OnTime method to schedule a repeating task. http://www.cpearson.com/excel/OnTime.aspx
