Module Opens previous workbook automaticly

Hi everyone!

I am facing a problem. I use a recalc module for automatic clock in my excle workbook. It seems to work fine. Howevery, when I close the workbook with the module and leave other excel workbooks (without any macros) opened, the workbook with the macros (the recalc module) keeps on opening up automaticly. This happens until I close all excel workbooks and open those I need - that stops the headache.

these codes I use:

MODULE 1:

Please Login or Register  to view this content.

In THIS WORKBOOK

Please Login or Register  to view this content.

And here is the big question: How to I stop the module from running and opening unwanted workbook automaticly?

Please note: I have no clue in VB and all the codes I've done were with the help of the pleasent people in this forum, so if you help, please be detailed

THnk you in advance!

Originally Posted by Norie

Are you running Disable before you close the workbook?

You could use this code in the ThisWorkbook module to do that.

Please Login or Register  to view this content.

I tried using the code you gave me, but it didn't help. THe workbook keeps on opening up. What I did is just copy paste it in the THisWorkbook mode. Maybe I need to do something else?

Thanks for helping!

In the workbook with the module.

exactly under the next code:

Please Login or Register  to view this content.