you can use the Windows Task Scheduler to run the macro at whatever time you
like

Alternatively, use a separate instance of Excel.

"JLR-Mart" wrote:

I have several macros that I run each day, some of which take up to an hour
to complete. Whilst they are running I cannot use Excel. Is there a way to
run macros in the background or, better still, have them run during the night
like a cron job in UNIX ???

Many thanks for any help.