Error handling only works in step thru

[S Oberlander]

The below code depends on another macro to have run first, so I put in some code to check if that macro ran and if not to call it.
It is also designed to be able to get called multiple times, and to skip some steps if it is being run the second time.

My code works when I step thru it. It also works if the first macro NonqualRates ran already, but if NonqualRates did not run yet it gets stuck by If Sheets("Exceptions").Visible = False Then; giving me Run-time error '9": subscript out of range.
What am I doing wrong? I told the code what it is supposed to do in case of an error.

Note, the way I check if the given macro ran already is by checking for a sheet that gets added and named within that macro

Sub IqmPossibile()

    On Error GoTo firstep
    If Sheets("Pivot").Visible = True Then GoTo secondstep
firstep: 'runs NonqualRatesl 
    Call NonqualRates
secondstep: 'checks if this is first run for IqmPossible
    On Error GoTo thirdstep
    If Sheets("Exceptions").Visible = False Then GoTo fourthstep 'this is where it gets stuck; the "False" here is not a mistake, it is checking for a hidden sheet.
thirdstep: 'does this only if it is the first run
    On Error GoTo 0
     'long winded stuff happen here, not relevant to my question
fourthstep: 'continue to userform
    IQMPossibilities.show vbModeless
    
End Sub

 

[Fluff]

You cannot use error handling like, have a look here as to why On Error WTF?

Which sheet gets added by the NonqualRates code?

 

[S Oberlander]

You cannot use error handling like, have a look here as to why On Error WTF?

Which sheet gets added by the NonqualRates code?

a sheet titled "pivot"

 

[Fluff]

Ok you can test for that like

   If Not Evaluate("isref(Pivot!A1)") Then
      Call NonqualRates
   End If

 

[S Oberlander]

Ok you can test for that like

   If Not Evaluate("isref(Pivot!A1)") Then
      Call NonqualRates
   End If

So for the Exceptions sheet I can do

   If Evaluate("isref(Exceptions!A1)") Then
      'here I want it should skip straight to the userform
   End If

which is much neater and probably the smarter way to do it too

 

[Fluff]

That's right.