My workbook keeps opening by itself!

[JamesFletcher]

Hi all,

I have just added some code to make my workbook close after it has been inactive for 5 minutes...this works fine except it opens itself up again after 5 minutes.
If I select 'Enable Macros' it closes immediately and if not, it will stay open.

Here is all of the code I put in for the auto shut down:
ThisWorkbook:

Please Login or Register  to view this content.

Module1:

Please Login or Register  to view this content.

Any ideas what is going on?

[Logit]

It has to do with "Application.OnTime". That command starts the Windows timer so your macro knows when the five minutes has been reached. What is needed is to stop the timer with syntax resembling ...

"Application.OnTime EarliestTime:=Now + TimeValue("00:05:00"), Procedure:=AutoSave, Schedule:=False"
The "Schedule:=False" being the key.

However, I am experiencing the same issue with my workbook and have been unable to get the above to actually work. A search of the Forum here will realize most folks are using : See http://www.cpearson.com/excel/ontime.aspx for understanding how to stop the timer. Except I am one of those folks who can't wrap my mind around the syntax to get it working in on my workbook.

If you manage to get your project to function as desired, please give my post a go :
http://www.excelforum.com/excel-prog...e-display.html

Thanks !

[Norie]

James

You seem to be using OnTime quite a lot in that code.

The only thing you don't do is disable it when you close the workbook.

Doing that should stop the workbook re-opening.

[JamesFletcher]

Thanks for your advice.

I added this macro to stop it opening and closing...seems to work so far!

Please Login or Register  to view this content.