VBA to Close Workbook if BOTH Workbook is inactive and VBA is Not Open

**teblowtime** · 05-23-2013, 09:46 AM

I have been searching high and low, but apparently nobody else has this need. I built an excel file for the department at my company that is accessed frequently by a few users. The file is still currently in development, so I need to regularly access the file for updates/maintanance. I am the only one that ever does any work in VBA, but the other users are notorious for opening the file and leaving their desk for hours at a time. I know how to implement an auto close/save routine if X amount of time has passed, however, it will still close even if I am working in VBA, which I, obviously, don't want. Any suggestions?

Another option I considered was implementing an

Please Login or Register  to view this content.

But I don't know the correct syntax (if it exists) to do that and I have had no luck finding any threads that detail how to tell if VBA is open or not.

Thanks.

EDIT: Figured out a work around. I added this if statement:

Please Login or Register  to view this content.

**Norie** · 05-23-2013, 10:03 AM

Why not stop/suspend the auto close/save code while you are working with the file?

**teblowtime** · 05-23-2013, 10:09 AM

I guess I could do that. I kind of just wanted something automatic so I didn't have to remember to suspend it and re-implement it every time I open and close. I know I'll forget to re-implement it. Haha.