Runtimer call module

On workbook open a module (calculate) is called, at the end of that module a Runtimer of 3mins calls to repeat the same module.

Please Login or Register  to view this content.

I have 2 issues

1- If the workbook is closed but excel still open or i open a different workbook after 3 mins it reopens the previous workbook... Presuming that a Runtimer is executing somewhere in the background still.
2 - If the first workbook is opened and i open another workbook after the 3 mins a runtime error occurs.

Hopefully i have provided enough info that makes sense, feel free to ask additional questions I'll respond asap.

A timer is global to an Excel instance. It is not specific to a file. If the timer is set to call a Sub in a file, and that file is not open when the timer files, that file will be opened so it can execute. You should have code in Workbook_BeforeClose to cancel the timer.

What runtime errors and on which line of code?

To do any meaningful troubleshooting on this we need to see all your code, not just the part that you are guessing is the issue.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I included the Workbook_BeforeClose, this resolved issue 1.

Issue 2

Please Login or Register  to view this content.

When i have another spreadsheet open after the timer it throws out a runtime error 9 subscript out of range. A debug shows this fault on line 2 of my code.
Is there no way round of having my Timer non global? (sorry new to this).
Basically, i want this spreadsheet open and updating in the background whilst working on another with no issues.

It is a best practice to not use Activate or Select and then assume through the rest of the code what is active or selected.

Line 2 of your code has illegal syntax, it is just a text string. I don't know what you are intending to do here.

I have rewritten your code with explicit qualifications, which hopefully resolves your runtime error.

Try this version:

Please Login or Register  to view this content.

Just apply the same principles I used to any code that you didn't include the first time. Don't use Select or Activate, and ensure every use of Range has a qualification. I'll help with it later today if I get a little time.

Originally Posted by Mmmdonuts

Still having issues when another workbook is open.

It does not appear that you followed any of my recommendations to solve that.