Function/sub exiting early except when called from Developer tab

I have a sub that performs a variety of actions such as taking inputs from a worksheet and outputting to another as well as modifying a chart object. I want the sub to be "volatile" so that it evaluates whenever any changes are made to the workbook. I've tried to make it both a Function and a Sub that is called by a separate volatile function but the end result is the same. For some reason the sub appears to exit early unless I call it from the Developer tab and not when a change is made on a worksheet however I don't want to do that since I want the evaluation to be automatic.

I've attached a simplified version of the workbook and the "exiting early" issue can easily be seen if breaks are placed on the three lines that output to the "K" worksheet.

As a second issue, the breaks also show that the sub evaluation isn't straight through and is bouncing from one line to another for some reason.

I'm still getting the same result after adding the extra few lines. Still seems to be jumping around a lot and the plotK sub isn't automatically producing the outputs that I'm looking for.

Ideally I would be able to get rid of the function that is calling the plotK sub but if there isn't another way to get the intended result then that would be acceptable as well.

Here is the original code if someone happens to pass by the post and doesn't want to download the attachment.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks, I didn't know this before. I have it doing what I want now with the Workbook_SheetChange event.