InputBox will not stop coming up

[Wouldsman]

I have entered the following code into my VBA to force the operator to fill in the necessary info
If the certain conditions are present.

Please Login or Register  to view this content.

The problem is it will not stop asking as you continue to fill out the form.

Any ideas would be greatly appreciated.

[walruseggman]

Yesterday, this was part of a Workbook_open event. Is it now part of a Worksheet_Change event?

If so, that endless loop can be fixed by adding these two lines as the first and last lines, respectively, in your _Change sub:

Please Login or Register  to view this content.

[Norie]

Where is the code located and how is it being executed?

[Wouldsman]

Yesterday, this was part of a Workbook_open event. Is it now part of a Worksheet_Change event?

If so, that endless loop can be fixed by adding these two lines as the first and last lines, respectively, in your _Change sub:

Please Login or Register  to view this content.

It is indeed now in Worksheet_Change.
And the Application.EnableEvents = False and Application.EnableEvents = True
Are already part of my _Change sub:

[walruseggman]

Then please post the workbook so we can troubleshoot what's going on.

[Wouldsman]

Then please post the workbook so we can troubleshoot what's going on.

As my workbook contains so much company info I was not able to post it I did however come up with something that is working.
I added a

If ActiveCell.Row > 6 Then GoTo jmp

and below row 6 I added

:jmp

I'm sure there are much better ways of doing this but it seems to be working for the moment.

Thank you all for your help on this.