Error handling in functions within other functions.

Hello,
In a sub, I create and format a spreadsheet. Then I call a function that pastes values in this sheet. So I call one last function that creates a graph from these values and, finally, I delete the sheet.
In each sub/function, I use "On Error GoTo OnErrorCase" to a message. However, if an error occurs within the sub inside the main one, for example (that one that paste data in the sheet), Excel stops, therefore an important part (delete the worksheet at the end) will not run.
That is, the "On Error GoTo" in the main subroutine doesn't include problems of internal routines. So if I want to "go back" (delete the worksheet in case of error), I must use "mysheet.delete" within each error treatment?

Your last "sub" deletes the temporary sheet? So why not just call that sub as part of your Error handling?

"Must" is the wrong word. You "can" do it that way. This is not a punishment, it's up to you what you want to handle inside your error handling. If your error handling calls an end to the whole process AND you want the temp sheet still to be deleted at the end, you'll have to design it that way. So putting that delete command into your macro is just as good as any other.

Why does your routine terminate completely if you have error handling inside each called sub? What does your error handler do?

On short, yes, you can put the sheet deletion into the section of your macro(s) that instruct what should happen during error handling.