Macro to run after 30 seconds

[randell.graybill]

Is there a way to make a macro delay for like 30 seconds before it does its thing? What I'm trying to do is have something turned off before the spreadsheet is saved, and after the spreadsheet is saved have a macro that runs 30 seconds afterwards to turn said feature back on. On error this macro will simply terminate.

[Leith Ross]

Hello Randell,

Here is simple macro to wait for 30 seconds...

Please Login or Register  to view this content.

[randell.graybill]

Thanks Leith.

[randell.graybill]

I tried it leath but the code stops the whole thing from running during the time the timer is set to wait...I want it to save first then wait 30 seconds not wait 30 then save.

[Leith Ross]

Hello Randell,

Call the macro "Delay Test" after your save the workbook. Like this...

Please Login or Register  to view this content.

[randell.graybill]

Beautiful, works like a charm thanks.