Thanks for the suggestions so far, I solved part of my problem.
While executing, VBA would add data to a worksheet. That would select that worksheet. The sheet with the chart that I was looking at would no longer be visible.
I was able to prevent that by removing:
Worksheets("Samplingplan").Activate
prior to writing to "Samplingplan", and addressing the worksheet instead by code like:
Worksheets("samplingplan").Cells(12, 10) = J_Decisions
This change allowed VBA to write to worksheet "samplingplan" without displaying it.
I am still having a problem being able to select manually between sheets. It works some with doevents, but not it's not very snappy. I will try some of the other suggestions unless I can make switching work faster.