Selected Answer
Regardless of whether you place your image in a Shape, an ActiveX control or a UserForm, it has to be repositioned on the screen when the scroll occurs. Unfortunately, Excel doesn't have an event that takes note of the Scroll event. Therefore there is no direct trigger that might cause the image to be moved.
It's possible to harness the Selection_Change event to this task but the resulting presentation isn't nice. The picture would scroll out of view and then reappear in its proper position only after the user clicks somewhere else. This sequence is probably self-defeating because the purpose of the picture is to assist the user in finding the correct click.
With the last possibility of meeting your requirement thereby removed there are two alternatives.
- Place the table D10:K20 in a modeless user form. Hide the scroll bars on the worksheet and enable scrolling of the table in the user form.
- Move the image to the top left of your form where it wouldn't be affected by scrolls due to the top part of the screen being frozen in place.
The programming involved in realising the first idea is substantial. Filling data into a form's controls takes much greater effort than filling them into a spreadsheet cell. Moreover, the number of rows in the form must be flexible, meaning controls must be created on the fly. All that promises a slightly sluggish process, not as smooth as pure Excel.
However, if the task were mine to implement I would be wary of using a modeless form. Basically, when a modal user form is shown it takes control of VBA until it's closed, when control referts to Excel. A modeless form stays open all the time. I neither know how control is divided between the two contestants - perhaps based on what is clicked, perhaps limited in scope - nor do I know what you require. In summary, you would be correct in saying that it's not a viable proposition.
That makes everything simple. Only one remaining option, and it's not difficult to implement.