Need help with auto close code

I've been working on this problem for days, I've run out of ideas. Here's the situation. I have several daily workbooks, each is for a resident in the pod I work on. Then there is a pod report workbook. The pod report workbook opens each of the daily workbooks, copies some data over then closes the workbook. The problem that I am running into is that all of the daily workbooks are opening back up after being closed by the pod report workbook.

Each of the daily workbooks has this in a standard module.

Please Login or Register  to view this content.

This code is in thisworkbook module

Please Login or Register  to view this content.

I need some help on this one I can't figure it out. Thanks guys.

Pod meeting starter file is password protected

Maybe try something like this in your workbook open procedure

Please Login or Register  to view this content.

Then in the pod report workbook, open each of the daily workbooks as read only. This will prevent its SetTime macro from being called on Open.

Please Login or Register  to view this content.