ExcelBanter - Start Macro every X Minutes

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Start Macro every X Minutes (https://www.excelbanter.com/excel-programming/330358-start-macro-every-x-minutes.html)

Zinewowe

Start Macro every X Minutes

Hi,
how can I automatically start a Macro every x minutes (as long as the
worksheet is open)?
Thanks
Zinewowe

Chip Pearson

Start Macro every X Minutes

You need to use the OnTime method. See
www.cpearson.com/excel/ontime.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Zinewowe" wrote in message
...
Hi,
how can I automatically start a Macro every x minutes (as long
as the
worksheet is open)?
Thanks
Zinewowe

All times are GMT +1. The time now is 10:01 PM.