Userform does not open with any other workbook open but only on second workbook launch.

Hello. Attached is my workbook with all confidential information removed.

Here is my issue:

If I have any workbook including a new empty workbook open and I launch my workbook, my userform appears. -But only the first time I open my workbook.

If I leave the first workbook open and close my workbook using a button I have to unload the form, save, then close the workbook and then simply re-open it, the userform does not appear. It seems to open on the first launch only.

When the userform does not open I can click the X and try to close excel which ordinarily is disabled in my code. I am then prompted to save the changes to the workbook.

I've been trying to determine the cause for this problem for a long with no success. Over time I've reinstalled the both the Office program and Windows, from new downloads.

Any help would be extremely appreciated. I'd really like to fix the issue.

In the btnclose_Click procedure in the FrmPunches module you disable the event response:

Application.EnableEvents = False

but there is no enable. When Help.xlsm was the only open file, this will close the workbook and the Excel application. At this point, the event response is reset, it takes the value True (it would be more true to say that when the Excel application is opened, the EnableEvents property gets the value True).
If the Help.xlsm file was NOT the only open file the workbook is closed, and the Excel application remains open along with other open files. At this point, EnableEvents has the value False, which means no events will occur, so reopening the Help.xlsm file will NOT trigger the Workbook_Open event procedure.

Artik

Ha ha. Well, now I feel silly. Thank you very much for taking the time to help me resolve my issue. I appreciate that.