Delay vba from running upon opening file

This is an interesting one, but hopefully an easy fix.

I have the following code below. It automatically closes a workbook after a set time, and works fine in doing so.

Problem is, it runs as soon as the workbook is opened... because of this, it seems to run before excel executes any initial warnings or yes/no pop ups. For instance, Security warning: "Do you want to make this file a Trusted Document?" only pops up after I stop the code... I want to delay the code below from running for say 30 seconds so that this warning can be submitted.
Otherwise, it acts like the warning is running in the background and therefore will not let the user click any of the toolbars/buttons.

I have tried

Please Login or Register  to view this content.

but this did not work and just span the cursor for 30 secs.

Please amend code below with added delay if possible/or adjust code if it could be written better and current issue could be avoided. Thanks in advance.

Please Login or Register  to view this content.

Can you explain what the purpose of the timer is?

The way I read it,

Please Login or Register  to view this content.

will delay opening the spreadsheet by TotalTimeInMinutes, which doesn't make much sense.

Originally Posted by xlnitwit

Hi,

Why don't you use application.ontime for this?

I tried application.ontime initially but I could not get it to work after many attempts so found the code which I am using above. application.ontime may suit better but I didn't have much luck with it.

If you feel you could adapt what I am after (below) to application.ontime then that would be ideal.

Originally Posted by mgs73

Can you explain what the purpose of the timer is?

The way I read it,

Please Login or Register  to view this content.

will delay opening the spreadsheet by TotalTimeInMinutes, which doesn't make much sense.

If I'm honest I'm not entirely sure. I'm new to vba and found the above code online.

All I want to achieve is for the spreadsheet to be closed and saved after 15 minutes of being open, with a 5 minute remaining warning after 10 minutes of being open.

For some reason, the code seems to remove any toolbar functionality from Excel, which I have diagnosed to be because the security warnings are running in the background as I outlined in my original post. I wasn't sure if another method such as application.ontime would remove this issue, or whether it would still be present, hence asking to see if the vba could be delayed from running by 30 secs or so...

Is anyone able to amend my code in the first post to help with this scenario? many thanks

Try this in the Workbook Module:

Please Login or Register  to view this content.

and then this in a standard module:

Please Login or Register  to view this content.

Thanks for this. The first part seems to work fine, i.e. I get the "This workbook will close in five minutes!" warning after 10 mins.... but then after the 5 minutes pass, I just get the "This workbook will close in five minutes!" warning again, then after another 5 mins I get it again, and again. Instead of the workbook closing?

Try the attached workbook, which works as expected for me. (I changed the minutes to seconds so I wouldn't have to wait so long to test).

Thanks. I think it was because I was pasting the module code in an existing module instead of creating a new one. Not been using VBA long so still learning where to place stuff! Placed in Module2 and appears to work fine - many thanks for your efforts.

I think it was because I was pasting the module code in an existing module instead of creating a new one.

Don't think that should make any difference, but if it works, it works!